Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: rose cruz
  Where is rose cruz?
 navotas
 Philippines
 rose cruz
 Tags
Subject: RE: VFP to Oracle
Thread ID: 193108 Message ID: 193142 # Views: 43 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Monday, September 08, 2008 12:49:05 PM         
   


> 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



COMPLETE THREAD
VFP to Oracle Posted by rose cruz @ 9/8/2008 9:46:17 AM
RE: VFP to Oracle Posted by surinder singh @ 9/8/2008 10:08:48 AM
RE: VFP to Oracle Posted by rose cruz @ 9/8/2008 10:17:22 AM
RE: VFP to Oracle Posted by surinder singh @ 9/8/2008 10:21:05 AM
RE: VFP to Oracle Posted by Anil Sharma @ 9/8/2008 5:32:28 PM
RE: VFP to Oracle Posted by Anders Altberg @ 9/8/2008 12:49:05 PM
RE: VFP to Oracle Posted by Ronan Masangcay @ 9/11/2008 6:10:12 AM