You need to actually submit the contents of the blob to each database and
obtain a new blob ID for each one.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of TI - Pública Informática
> Sent: Thursday, July 13, 2006 6:09 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Transactions with many connections
>
>
> 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