Hii all,
Can anyon tell me how to store and retrieve an image in MySQL BLOB field.
I'm already using FileToStr() and StrToFile() function which are works fine in VFP native table, but still not work when try to update MySQL table.
This is My Code to update MySQL Table. Thanks


Local MCommand, MPict, MPict1

MPict = FiletoStr("C:\AVFP\SWIFT.JPG")
MCarId = "SWIFT"
MPict1 = Cast( MPict1 AS BLOB )

MCommand = "Update Cars Set Pict1 = ?MPict1 Where CarId = ?MCarId"

SQLEXEC(M_IdConnection, MCommand)