>>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