Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Big strings
Message
De
02/07/2007 08:46:52
 
 
À
02/07/2007 08:33:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Divers
Thread ID:
01237101
Message ID:
01237106
Vues:
14
This message has been marked as the solution to the initial question of the thread.
>Hi..
>
>If the variable 'lcvalues' on the following expression gets a big size.. only truncate and the sql expression is not accepted..
>
>Does anyone, could share any solution to concatenate it..
>
>
>lcsqlstring  = "INSERT INTO " + lctable + " ( " + lcsqlfields + " ) VALUES (" + lcvalues + ")"
>
>
>TIA
>
>Claudio

You can change your approach and use INSERT ... From Name oObject. This way it will never be too long expression.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform