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 TouchToneTommy 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: *

  1. koniba

    updating several tables

    Thank you very much for responding so quickly to my question. I will try this right away. Thank you again, Koniba.
  2. koniba

    updating several tables

    Thanks very much. However, I tried yours and I got two errors messages 1) Variable must be declared first. I declared a variable And got: 2) "Invalid Character" for "@@" sign preceedint the "INDENTITY". When I run my own statement on the sql query analyzer the...
  3. 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...
  4. 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