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
40
41
42
43
44
45
46
47
48
49
50
|
CString buffer[2];
query.Format("SELECT CONVERT(BINARY, BLOB_0) AS BLOB_0 FROM CBLOB WHERE IDENT1_0='%s' AND IDENT2_0=''", fp.article);
base->ExecuterRequete(query, record);
if (!record->IsEOF())
{
record->GetFieldValue((short)0, buffer[0]);
LoadImage(fp.photo_produit, buffer[0]);
record->Close();
}
(...)
int CBase::ExecuterRequete(CString requete, CRecordset * recordset)
{
if (this->IsOpen() == 0)
{
int ret = this->Connecter();
if (ret!=0)
return ret;
}
if (recordset->IsOpen())
recordset->Close();
try
{
recordset->Open(CRecordset::snapshot, requete);
}
catch(CDBException* e)
{
this->Deconnecter();
e->Delete();
return CANNOT_EXECUTE_REQUEST;
}
if ((recordset->IsEOF()) && (recordset->IsBOF()))
return 0;
try
{
recordset->MoveFirst();
}
catch(CDBException* e)
{
this->Deconnecter();
e->Delete();
return CANNOT_EXECUTE_REQUEST;
}
return 0;
} |
