kuuku


I have table AB which is a VFP table and table CD which is in an Oracle database. Is it possible to compare the records in table AB with that of table CD and then create a new table in VFP for the records in AB not in CD using VFP and if so how is it done





Re: Comparing VFP table Records with an Oracle database table

AndyKr


>>I have table AB which is a VFP table and table CD which is in an Oracle database. Is it possible to compare the records in table AB with that of table CD and then create a new table in VFP for the records in AB not in CD using VFP and if so how is it done

First you need to create an ODBC connection to the Oracle Database. You will need to install the Oracle PC Client, and probably need instructions from your DBA about which instance to access, UserName and Password and so on.

Once you have a connection you can simply create a remote view inVFP of the Oracle table and treat it as if it were a native VFP table (USE, TableUdate() and so on will all work as usual). If you feel you need to do more, then look into SQL PassThrough (see SQLCONNECT(), SQLEXEC() and SQLDISCONNECT() in the help file for details).