Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SMA00
  • Order by date
  1. SMA00

    How to Display Record in DBGrid

    Hi Friends, I have ADODC control, DBGrid1 Control and following SQL statemnt. SQL = Select custid, name, address from Customer I am unable to display in my result in DBGrid1. Can you guide or provide sample how to bind the and display result in dbgrid. What setup do i need to use in ADODC1...
  2. SMA00

    SQL Result in List Box

    Hi Harleyquinn, I have ADODC1 control and DBGrid1 Control. SQL = Select custid, name, address from Customer I am unable to display in my result in DBGrid1. Can you suggest what setup do i need in ADODC1 and DBGrid1 to display record. Best Regards SM
  3. SMA00

    Looking for SQL UPDATE Query

    Hi Vongrunt, Great Job Vongrunt. Query works fine as i tested with 50 records. I will update tomorrow one of my table having 40000 records. Thanks Very much for your support. Best Regards SM
  4. SMA00

    Looking for SQL UPDATE Query

    Hi Vongrunt, Thanks for your promt reply. As long as Salesman and Srno are maintain unique any order will be fine. Looking for you reply. Best Regards, SM
  5. SMA00

    Looking for SQL UPDATE Query

    Hi Friends, I have following query looking for solution. Table AAA ; SalesmanID char (02) Customer ID char (15) NRec int Srno int Existing Data: SalesmanID Customer ID NRec SRNO 90...
  6. SMA00

    SQL Result in List Box

    Hi, I am unable to insert following SQL Statement Result in to List Box. Can some one guide me with code how to do it. SSQL = Select custid, name, address from Customer SM
  7. SMA00

    How to Calculate Avg. Price from the following table

    Hi Guys You should ignore the record if QtyRecd - QtySold = 0 becuase there is no need for the item Average caluclation which is not in stock. Regards AR
  8. SMA00

    How to Calculate Avg. Price from the following table

    Hi Friends, I am Looking for Procedure or SQL Script to Calculate Average price for the following Each item number. Formula: (Qty Recd - QtySold) * unit price / (Qty recd - qty sold) for Each item ItemCode Receipt# Qty Recd. Qty Sold Unitprice A001 RCT001 10...
  9. SMA00

    Re: SQL Trigger Update Delete

    Hi Guys, It works Great !!!! Thanks for your Tips & Code. Regards Shaikh
  10. SMA00

    Re: SQL Trigger Update Delete

    Hi we have Inventory Trx table which does not maintain history of changes. I would like to record it using Trigger on table INV90001 where if user changes any record or delete i want to record changes in New table called AUDIT900. Can some one provide the code how to write trigger on table...

Part and Inventory Search

Back
Top