> 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.comCheck my blog for details:
http://weblogs.foxite.com/sur200----------------------------------------------------------------------------------------
*If you understand what you're doing, then you're not learning anything.