Load Image From Db Problem

[VRonin]

yep, you should check QSqlQuery::bindValue

sql.prepare("UPDATE Patient_File SET SskeletonPic= :skp  WHERE SmeliCode= :smc");
sql.bindValue(":skp",inByteArraye);
sql.bindValue(":smc",seMcode);
sql.exec();

this also prevents SQL Injection. You should never really use unescaped input directly to build the query string

[M4RZB4Ni]

@VRonin
thanks but my problem is in Load image not save it!
Thank a lot My Friend :)

[VRonin]

make the field varbinary(max), save it that way and the code you have will work, no changes needed on the load part

image in SQL server is a fixed length string. it has nothing to do with images

[Kutyus]

Hi!
The same problem, you could solve?
Thanks

[VRonin]

@Kutyus

Summary of the above:

• in the database use the type VABBINARY not IMAGE
• use QSqlQuery::bindValue instead of string concatenation to build your query

[Kutyus]

@VRonin Thank you for reply, but my problem is the load image from database, please see my another question:
QT 5.8 image from database error