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 derfloh 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
  • Content: Threads
  • 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

    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...
  3. 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
  4. 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...
  5. 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