>>Hi All
>>
>>I use VfpEncryption.fll to encrypt some of the data. When I try to upload a table, which contains the encrypted information onto a MSSQL database, the insert is failed.
>>
>>Here is my insert command
>>
>>TEXT TO lcCommand NOSHOW TEXTMERGE
>> INSERT INTO GENERALSETUP (chaudnomen1)) VALUES ('<<m.chaudnomen1>>')
>>ENDTEXT
>>lr = SQLEXEC(Handle, lcCommand)
>>
>>If I STRTOFLE(lcCommand,…) here is what the command looks like
>>INSERT INTO GENERALSETUP (chaudnomen1)) VALUES ('IõUú.á÷þ_ :_¨âÍ_²UAÝ@Š
>>ÄžÂ_.fðgÅÁª’Nº
>>)Í4_€ì_oh8‹‹…V_þ;4`7ç_6à')
>>
>>What do I need to do to make it load into my MSSQL data?
>>
>>Thank you
>>Yelena
>
>Just a first idea that comes to mind - can you pass m.ChaudNomen1 as a parameter instead of the string concatenation?
Thank you Naomi for the quick reply.
Do you mean using some sort of stored procedure instead of the sql passthrough? The problem is that this is my upsizing routine and my SQL database is just created in the same program and now I am uploading data.
Yelena