Knowledgebase
[QODBC-Desktop] How to connect and use FoxPro with QODBC
Posted by Jack - QODBC Support on 19 October 2016 07:22 AM

How to connect and use FoxPro with QODBC

Open Visual FoxPro from Start Menu:

 

FoxPro started:

 

Open "Command Window" from Windows Menu:

 

"Command Window" Opened. You can execute FoxPro commands from the "Command Window."

You need to write FoxPro commands in the "Command Window" & execute it by hitting the "Enter" key on the keyboard.

 

First, We will connect to QuickBooks from FoxPro using SQLCONNECT command. Write the below command & hit the "Enter" key from the keyboard.

CN = SQLCONNECT('QuickBooks Data', '', '')

 

Now, We will execute the query to QuickBooks from FoxPro using the SQLEXEC command. Write the below command & hit the "Enter" key from the keyboard.

SQLEXEC(CN , "SELECT TOP 10 Name FROM Customer","csrCust")


Note: The above query is for testing purposes only. You can change the query as per your requirement.

Now, We display query results in FoxPro using the BROWSE command. Write the below command & hit the "Enter" key from the keyboard.

BROWSE

 

Query Result:

 

You can disconnect the connection to QuickBooks from FoxPro using the SQLDISCONNECT command. Write the below command & hit the "Enter" key from the keyboard.

SQLDISCONNECT(CN)

 

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).