Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: surinder singh
  Where is surinder singh?
 Hyderabad/New Delhi/Kangra
 India
 surinder singh
 To: rose cruz
  Where is rose cruz?
 navotas
 Philippines
 rose cruz
 Tags
Subject: RE: VFP to Oracle
Thread ID: 193108 Message ID: 193113 # Views: 58 # Ratings: 1
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Monday, September 08, 2008 10:08:48 AM         
   


> 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...

you need to connect to oracle database from foxpro by using sqlstringconnect
then after connecting you can run SQL commands to insert/delete/update data
in your oracle database
gnConnHandle=SQLSTRINGCONN('DRIVER={Microsoft ODBC for Oracle};' + ;
   'SERVER=MyServer;UID=MyUserID;PWD=MyPassword')
IF gnConnHandle>0
   lnResult=SQLEXEC(gnConnHandle,"select * from yourTable,"yourCursor")
   IF lnResult>0
      select yourCursor
      browse
   ENDIF
   =SQLDISCONN(gnConnHandle)
ENDIF
					


-----------------------------------------------------------------------------------------------
Regards
Surinder Singh
Email: sur200@indiatimes.com
Check my blog for details: http://weblogs.foxite.com/sur200
----------------------------------------------------------------------------------------
*If you understand what you're doing, then you're not learning anything.



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