Compaaring DBTables with BLOB fields
Hi, I have a "DBTable" compare with text fields that works pretty fine. But I have another, with a BLOB field that systematicaly outputs a different hash value even if I compare it with himself....
Forum Discussion
Hrm... is the BLOB an image? If so, it might be better to extract the BLOB from SQL and do a separate image comparison rather than a DBTable comparison.
thank you for answering tristaanogre,
no it's a "memo" field in MS Access database that TestComplete recognizes as a BLOB field...
thanks you all for this help,
I finaly used a ADO dataset and read the value I wanted directly. The "Memo" (BLOB) field is read "AsString" which is what I needed.
I used this piece of code :
procedure TestProc;
var
DSet : OleVariant;
begin
// Create the new IAQAADODataset object
DSet := ADO.CreateADODataset;
// Specify the connection string
DSet.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;' +
'Data Source=C:\Microsoft Visual Studio\VB98\biblio.mdb';
// Specify the command type and text
DSet.CommandType := cmdTable;
DSet.CommandText := 'Publishers';
// Open the dataset
DSet.Open;
// Process records of the Publishers table
DSet.First;
while not aqConvert.VarToBool(DSet.EOF) do
begin
// Insert data into the test log
Log.Message(DSet.FieldByName('Name').Value, DSet.FieldByName('Address').Value);
DSet.Next;
end;
DSet.Close;
end;
