>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
Gerard,
255 limit only applies to string litereals (anything within quotes IOW). Otherwise with a single SQLExec command you could insert data that is hundreds of Mbs in size. Check this for a sample:
Re: Updating SQL Files from VFP Thread #
1204946 Message #
1204989Cetin