1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
try{
IbSgbd->IBQuery1->Close();
IbSgbd->IBQuery1->SQL->Clear();
Graphics::TBitmap *pBitmap = new Graphics::TBitmap();
pBitmap->LoadFromFile("o_live_bass.bmp");
DBImage1->Picture->Bitmap=pBitmap; // afiiche l'image a la main
TBlobStream *pBs; // pt sur BlobStrem
TStream *pSt; // pt sur Stream
IbSgbd->IBQuery1->SQL->Add("INSERT INTO ARTICLES ( NOM,PRIX,STOCKACTUEL, "
" STOCKMINIMUN ,IMAGE ) "
"VALUES (:NOM,:PRIX,:STOCKACTUEL,:STOCKMINIMUN,:IMAGE)");
IbSgbd->IBQuery1->ParamByName("NOM")->AsString="o_live";
IbSgbd->IBQuery1->ParamByName("PRIX")->AsCurrency=1.45;
IbSgbd->IBQuery1->ParamByName("STOCKACTUEL")->AsInteger=1;
IbSgbd->IBQuery1->ParamByName("STOCKMINIMUN")->AsInteger=1;
pBitmap->SaveToStream(pBs); // violation d'acces
IbSgbd->IBQuery1->ParamByName("IMAGE")->LoadFromStream(pBs,ftBlob );
IbSgbd->IBQuery1->Prepare();
IbSgbd->IBQuery1->ExecSQL();
IbSgbd->IBTransaction1->Commit();
}catch(...)
{
IbSgbd->IBTransaction1->Rollback();
} |
Partager