General information
Category:
Coding, syntax & commands
The only such limit of which I'm aware has to do with Memo fields and truncation at 254 characters with the SQL Insert command. Cetin Basoz demonstrated a way around that using ADO that seems to work fine.
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only