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 bkrike 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: koniba
  • Content: Threads
  • Order by date
  1. koniba

    how to get the last product id and increase it by one "very urgent"

    I am very new in sql and asp. I am updating several table with information. I needs to capture the last product id in the Product table and increase it by before inserting it in other tables. How do I do that using vbscript and sql? Dim proid proid = "SELECT (Last_ProductId) + 1 FROM...
  2. koniba

    updating several tables

    I have several tables where I want to add information to for a user interface which does not have the productid. So I want to capture the last productid and (1) to it for the next productid and insert that id info into three tables ( commnets, phase, phasedescription). Here is what i think will...

Part and Inventory Search

Back
Top