>>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é