Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Big strings
Message
From
02/07/2007 13:10:51
 
 
To
02/07/2007 08:46:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01237101
Message ID:
01237172
Views:
23
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform