[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 QODBCOpen 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")
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)
| |
|