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 Mike Lewis 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. bonjourno

    Replace function doesn't work when I cross reference 2 tables

    This is in Oracle. Yes you still need the semi colon to run SQL scripts. The TEXT_VALUE is only in TABLE1
  2. bonjourno

    Replace function doesn't work when I cross reference 2 tables

    I would really appreciate help with this one I want to update records in Table1 using REPLACE, only if they meet certain conditionS in TABLE1 and in TABLE2. The regular update using just the SET statement works fine, but when I use the REPLACE statement I get errors. This is my code: UPDATE...
  3. bonjourno

    add a filter when looping thru a recordset

    Thank you very much sir... your solution with the IF statement worked just fine. [thumbsup2] Regards!!
  4. bonjourno

    add a filter when looping thru a recordset

    Hi there, I'm using the code below to loop through a record set and select Email addresses of certain users to send them email automatically. How can I modify this code so I can add a filter.?? I want to select only users that belong to certain Group(Group is a Text field in the tbl_users) and...

Part and Inventory Search

Back
Top