Any one in forum have experience working with ASTADOAServer ?
Please drop me some code to execute Update/Insert BLOB field.
in 2 tier i usualy use below code to update blob:
// insert into lobtable (id, lobcolumn) values
id, empty_blob())
// returning lobcolumn into :lobcolumn
with LOBQuery do
begin
SetVariable('id', 1);
// Create a new BLOB (initially Null)
LOB := TLOBLocator.Create(Session, otBLOB);
// Assign it to the returning variable
SetComplexVariable('lobcolumn', LOB);
Execute;
// After the insert, use the LOB Locator to write the data
LOB.Loadfromfile(file);
end;
but in ASTADOAServer i've read source code and detect it only support LONG RAW type not BLOB
Regards
Please drop me some code to execute Update/Insert BLOB field.
in 2 tier i usualy use below code to update blob:
// insert into lobtable (id, lobcolumn) values
id, empty_blob())// returning lobcolumn into :lobcolumn
with LOBQuery do
begin
SetVariable('id', 1);
// Create a new BLOB (initially Null)
LOB := TLOBLocator.Create(Session, otBLOB);
// Assign it to the returning variable
SetComplexVariable('lobcolumn', LOB);
Execute;
// After the insert, use the LOB Locator to write the data
LOB.Loadfromfile(file);
end;
but in ASTADOAServer i've read source code and detect it only support LONG RAW type not BLOB
Regards
