> Hi, is there someone who can help me where can i find a tutorial or e-book how can i manipulate data at Oracle using vfp. Thanks...
I googled for the words "visual foxpro" oracle
Google reported 305000 pages found.
The answer should be 'yes' (but not from me for Oracle).
There are three approches in VFP:
'remote views'. View definitions (and connection data) are stored in a VFP database as SQL SELECT queries; Updates and Inserts on the buffered result cursor of the view are automated to use TableUpdate() or TableRevert().
The View Designer facilitates the work of configuring the update criteria for the view.
'SPT' which means 'SQL PassThrough' which is done with the functions whose name
begins with SQL.., such as SQLCONNECT() and SQLEXEC(). You pass SQL SELECT, UPDATE, INSERT, and other SQL commandfs commands straight to the Oracle database.
The 'CursorAdapter' class, aka 'CA'. Mixes functionality of remote views and SPT, usually by way of an OLE RecordSet object.
All three can be based on an ODBC connection; the CA usually uses an OLEDB connection instead.
All are extensively documented in the Help for VFP.
-Anders