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 Wanet Telecoms Ltd 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: Agro42
  • Content: Threads
  • Order by date
  1. Agro42

    SQL return code in VBscript

    Ok, I've searched the web with Google, and I've read over 100 Q&As on this forum, but I can't find anywhere how to get the SQL return code out of a recordset after an insert. I am doing inserts of records that come from an outside vendor, and they often send records with duplicate keys. I want...
  2. Agro42

    Update using join of 2 tables

    I need to update 1 table from another table. Simple enough, but I can't get it to work. Here are my tables and the important fields: APRF stulink testlink passfail testdate ATPA stulink testlink (not the same as APRF.testlink) partnum (IS the same as APRF.testlink) scoreone admdate There is no...
  3. Agro42

    Need to update 1 table from another

    I need to update a DB2 table with values from a temporary table, populated from a file. The ASTU is my student record table, the EPS_CODES is my temp table. ASTU contains about 100 fields, the only one of which I need to update is named ENGPROF. The PK is PERMNUM. EPS_CODES has 3 fields...

Part and Inventory Search

Back
Top