Load Image From Db Problem

[VRonin]

i don't get the threading thing but it's probably not the point here. where did you get the
"Cant Convert varchar datatype to VARBINARY(MAX)" error?

[M4RZB4Ni]

@VRonin
when i want insert image into database after capture screenshot

[VRonin]

Can you post that code please?

[M4RZB4Ni]

@VRonin
yes of course
thanks so much

this is code :

void Medical_Records::initalizeVarables()
{

        shootScreen();
        QBuffer inBuffer( &inByteArraye );
        inBuffer.open(QIODevice::WriteOnly);
        originalPixmap.save(&inBuffer,"PNG");
}
void Medical_Records::submitWithScreenShot()
{

  initalizeVarables();
    QSqlQuery sql;
    sql.exec("UPDATE Patient_File SET SskeletonPic='"+inByteArraye+"' WHERE SmeliCode='"+seMcode+"';");
}

[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