Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing Image to SQL VarBinary Problem
Message
 
To
20/07/2007 17:06:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01242501
Message ID:
01242502
Views:
37
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform