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


Thanks a Lot...Godbless

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



Thanks a Lot...Godbless



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