I am uisng a Sqlexec to 'Insert' VFp table into SQL, but am coming up with the 255 limit.
All field names are c 10 characters and I have about 20 of them so I reckon I am going to exhaust this linit, with just the field names bit, not to mind the Values bit.
Is there any way round this. Even if I use the insert for the first field, I could use the Update for the rest, but I would need to get back the primary key in the Sql file, which is autogenerated ?

Maybe theres another way ??

Any help appreciated .
regards,
Gerard