If I add 0x to it, I receive "incorrect syntax near '0x'"
If I leave off the 0x, I receive "incorrect syntax near ','"
In both cases, it is exactly the first character in the lcfile2 string.
>>MyImage is varbinary(max) null
>>
>>cMyImage = 'C:\mypath\myjpg.jpg'
>>lcfile2 = "'"+FILETOSTR(cMyImage)+"'"
>>lcFile3 = "'"+CREATEBINARY(FILETOSTR(cMyImage))+"'"
>>TEXT TO lcSQL NOWSHOW PRETEXT 15 TEXTMERGE
>> INSERT INTO MySQLTable (MyKeyField, MyStatus, MyLastName, MyImage) VALUE (5,'A','Jones',<<lcfile2>>)
>>ENDTEXT
>>?sqlexec(6,lcSql)
>>
>>
>>Yet it fails onthe MyImage field using lcfile2 or lcfile3. Any idea why?
>
>I can't imagine you wrote this:
>hard coded sql connection and no error check with AERROR() :-)
>What AERROR() says?
>
>Did you try with:
>
><<[0x]+lcfile2>>
>
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"