Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing VFP Data from RDO
Message
From
01/03/1998 11:21:58
 
 
To
01/03/1998 01:46:11
Jay Shepherd
Construction DataFax, Inc.
Montevallo, Alabama, United States
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00081935
Message ID:
00081966
Views:
18
>I'm working with KB article Q172592: HOWTO: Open a Visual FoxPro Table for Read/Write.
>
>In the example code, that they give you, they show the following syntax for opening a table.
>
>Set rs = cn.OpenResultset(SQL, rdOpenKeyset, rdConcurRowVer)
>
>When I try these parameters, I get an ODBC Error: 'Driver Not Capable'
>
>What I need to be able to do, is open a VFP 5.0 table and be able to EDIT it. I can open readonly with no problem.

If that causes you a problem, you may create a Visual FoxPro DLL that will allow you total control of it by using Visual FoxPro command from Visual Basic. I did that once because they was a lack of control in VB and it was the perfect solution for us to do. The VFP DLL was extremly simple by allowing us to establish an object with VFP and doing VFP commands from there.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform