Christof...

FWIW, the line in question is not a typo. It is in the context of Miriam's Access examples. In Access, the table name is customers, not customer..< s >..

Further, just telling Marcel to change the name won't cut it. Rather, you need to use the options parameter since the VFP ODBC Driver is not smart enough to distinguish between a SQL statement, a table name, or command text. Therefore, to get the same results with VFP data, here is the proper code:

ors.open("customer",oconn,3,4,512)





>Hi Marcel,
>
>>>ors.Open("customers",oconn,3,4) && just use the table name.
>>
>>Is this possible with VFP data ?
>
>Yes, if you fix the typo in the above line. It should be "Customer", not "Customers".
>
>Christof