> Thanks a Lot...Godbless
>
> >
> > 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

if u find surinder post is helpful to u or solved your problem so please give rating to that answer so others can get benefit from that by checking the answer directly.


Anil
(Fox is the solution for almost everything!!)