>i am trying to access a vfp database through the microsoft odbc driver version 5.00.00xx.
>
>my application works fine until the I added the 50th field to one of the tables. at that point the driver reported an error 'SQL statement too long'. actually, i can get a few more fields if i shorten the field names. the problem seems to be with the overall length of field names. (it seems that the driver formats a sql string containing all field names even if only one is being updated).
>
>this happens if i access the database with VB and RDO or using Delphi's database explorer. so i am reasonably certain that the problem is with the odbc driver.
>
>
>question:
> is there a better or more recent driver?
>
> is there a better way to access vfp data from a front-end application?
>
>
>thanks
>bill
Bill,
My guess is that the problem is even worse, it is with VFP. From within VFP, define a view and try to update more than say 25 fields in one shot. You'll get this same "SQL statement too long message". I really hope they'll fix that in Tahoe.
José