> Yes sir, I do !
>
>
>
> object documente: TIBDataSet
> Database = database
> Transaction = trans
> ForcedRefresh = True
> BufferChunks = 1000
> CachedUpdates = False
> DeleteSQL.Strings = (..')
> InsertSQL.Strings = (..')
> RefreshSQL.Strings = (..
> SelectSQL.Strings = (..
> 'select * from DOCUMENTE order by id_documente')
> ModifySQL.Strings = (..
> GeneratorField.Field = 'ID_DOCUMENTE'
> GeneratorField.Generator = 'ID_DOCUMENTE_GEN'
> Left = 16
> Top = 392
> end
>
>
> object miscare: TIBDataSet
> Database = database
> Transaction = trans
> ForcedRefresh = True
> BufferChunks = 1000
> CachedUpdates = False
> DeleteSQL.Strings = (..
> InsertSQL.Strings = (..
> RefreshSQL.Strings = (..
> SelectSQL.Strings = (..
> ModifySQL.Strings = (..
> GeneratorField.Field = 'ID_MISCARE'
> GeneratorField.Generator = 'ID_MISCARE_GEN'
> Left = 280
> Top = 240
> end

Doesn't tell us anything about your transaction management, does it?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

>
> Tiberiu
>
>
> Make sure you commit all your changes and/or use the same
> transaction for all "save" actions.