>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>>
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.