Without changing the Oracle database (putting triggers in the set some sort of update rquired flag), it's going to be difficult and, maybe, not worth the effort. Is there a reason why you don't just have remote views on the Oracle tables and create indexes on the views at app startup?
>I am writing a client server application that requires the use of 16 lookup tables that I would like to store locally on each users workstation or on a shared network drive. These lookup tables are fairly static an occupy less than a meg with index files. What is the best way to compare these local tables with the equivalent tables in an Oracle database. The intent is to only refresh the local individual table when the Oracle table has been updated. I would want to check if the tables have changed each time the user starts the application. Any suggestions would be greatly appreciated.
>
>Thanks,
>
>Greg
>
>P.S. Using VFP 6.0 SP3 and Oracle 7.3.3
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05