Hi Gerard,
I don't know if you've been following the cricket, but congrats on beating Pakistan!
My preference for long SQL strings is to do this:
TEXT TO m.lcSQL NOSHOW TEXTMERGE
SELECT a, b, c,
FROM my Table
ENDTEXT
llSuccess = SQLEXEC(m.lnHandle, m.lcSQL, "c_Result")
This way you can have as long an SQL command as you need
>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