Hi,

I am using one transaction in more than one connection to post all the
alterations in two databases. If modified field is a blob field then return
a error:

ISC ERROR CODE:335544329

ISC ERROR MESSAGE:
invalid BLOB ID

Solution ???

The code is:
with dataset do
for ii := 0 to FieldCount - 1 do
with Fields[ii] do
if IsModified and not ReadOnly and not Computed then
begin
ASQLDA.SQLVAR[jj] := PSQLVAR^;
end;

for ii := 1 to IB_Transaction.ConnectionCount-1 do
begin
errcode := isc_dsql_execute_immediate(@status,
IB_Transaction.Connections[ii].PdbHandle,
PtrHandle,
Length( edSql ),
PChar( edSQL ),
IB_Connection.SQLDialect,
ASQLDA );

if errcode = 0 then
WasUpdated := true
else
HandleException( Dataset );
end;

Thanks.

Airison Ambrosi
Analista de Sistemas
Pública Informática Ltda
47 - 3326 3331