Subject Transaction problems
Author rodbracher
Hi

I have a transaction that essentially imports records - check to see
if there is an existing key ( edit ) or none ( inserts ). I then
update all those records with an update statement ( execSQL ). This
causes a 'Connection Lost To Database' ( in the interbase.log I get
IBServer terminated abnormally )

Is it bad to use edit/inserts and post along with execSQL statements
in the same transaction ?

I also have not changed ( or ever used the TimeOutProps ). Could this
possibly cause the connection loss ( The import size varys but
usually 5000 records / relation * 9 relations are imported ) and I
see the Default TimeOutProps.Attempt is some number lower than that.

Thanks

Rod