Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to access ORACLE tables from VFP 1

Status
Not open for further replies.

petervfp

Programmer
Oct 19, 2001
7
CA
I've used FP 2.x for years but am fairly new to VFP. I have my ODBC drivers in place and an ORACLE database and VFP 6.0. How do I run a simple SQL statement from the VFP command line against the ORACLE table? I assume I'll need to open a connection to the db... but how (I have a host name, db name and all the passwords etc)? Then how do I issue the SQL so it runs against the ORACLE tables? Help me!!!
 
look at the sqlconnect and sqlexec functions. Also look at remote views.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top