By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,341 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,341 IT Pros & Developers. It's quick & easy.

comparing records of oracle table with access table

P: 27
I am trying to compare records from oracle table with a table in access. With oraDynaset, I have the option of .findNext function. I can use that to look for matching records from access to oracle.
My problem is: I have to look up in access table and delete the records from oracle table if a certain record is not available in the access table.
Is there a way of doing that ? Can I get some help ?
To make my point more clear, here is the code , I can look up in oracle dynaset with the following function :
Expand|Select|Wrap|Line Numbers
  1. For x = 1 To created_to_compare_rstFE_Log.RecordCount
  2.    rec_ora.FindFirst ("FE_LOG_UID = " & created_to_compare_rstFE_Log   ("UID"))
  3.    If rec_ora.NoMatch Then
  4.        rec_ora.Delete
  5.    End If
  6.    If Not created_to_compare_rstFE_Log.EOF Then
  7.        created_to_compare_rstFE_Log.MoveNext
  8.    End If
  9. Next x
  10.  
My question is how can I look up in access table ? I have tried using .find function of ado but am facing troubles. I need some help, thanks
Nov 14 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.