Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bug in ODBC driver?
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00256956
Message ID:
00257745
Views:
23
>>I have a problem with the ODBC driver of VFP 6. I try to get data of a view via the ODBC driver (in VFP6), the result is none record. If I open the view directly with VFP 6 the result is 3 record. Any suggestions?
>
>Sorry I forget to tell you the version of the driver: 6.00.8428.00

Karsten,

When using the ODBC driver you're playing with "remote" data and must treat it with the appropriate SQL commands.

That is, for a local view you would write WHERE Comptes.Comp = ?vp_cCompte.
With a remote view, you'll have to use the like operator: WHERE Comptes.Comp LIKE?vp_cCompte

José
Previous
Reply
Map
View

Click here to load this message in the networking platform