Knowledgebase: Connection
[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 "Command Window".

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

 

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

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

 

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

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


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

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

BROWSE

 

Query Result:

 

You can disconnect the connection to QuickBooks from FoxPro using SQLDISCONNECT command. Write below command & hit "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).