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