Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement