Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Big strings
Message
De
02/07/2007 13:10:51
 
 
À
02/07/2007 08:46:52
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:
01237172
Vues:
22
>>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 + ")"
>>
>
>You can change your approach and use INSERT ... From Name oObject. This way it will never be too long expression.

after moving foward and backward on a day long move.. I found a solution on the direction of yours advice.. thanks..
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform