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 Chris Miller 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: zubby
  • Order by date
  1. zubby

    Recordset Filtered Update

    I am trying to update only non-filtered rows from a recordset. I am trying to do this by: 1. Create rs 2. Filter out un-wanted rows 3. Create a new rs based on the un-filtered rows 4. Update new rs How do I do #'s 3 & 4 and keep all of the rs attributes the same, col names, etc... Thanks
  2. zubby

    Preview SQL before Update

    When using ADO, and writing an update statement, EXAMPLE: Update a_table Set a_column = :a_value Where a_keycol = 'XYZ'. Before the update statement is executed, can I see the update statement that the DATABASE is going to perform, NOT the update statement that I wrote?
  3. zubby

    SQL Preview

    When using ADO, and writing an update statement, EXAMPLE: Update a_table Set a_column = :a_value Where a_keycol = 'XYZ'. Before the update statement is executed, can I see the update statement that the DATABASE is going to perform, NOT the update statement that I wrote?
  4. zubby

    SQL Preview

    Is there a way to see the exact SQL the database will use before performing an update? For example, can you control if the database will issue an update or a delete and insert?

Part and Inventory Search

Back
Top