The program doesn't keep transactions open. For the data that was lost,
we use non-data aware, data entry screens that pass the data to a query
manager that creates the transaction, inserts data, commits the
transaction. There is another non-auto created form where the user
creates little memos with a data aware screen which uses:
TSQLConnection->TSQLDataSet->TDataSetProvider->TClientDataset, and when
closed calls TClientDataSet.ApplyUpdates.

I suppose though since the transaction is handled by the TSQLConnection
component, which the main form creates, I should add a safety check on
close of the main form to verify InTransaction. What is the default
behavior if there was an active transaction and the TSQLConnection
component was destroyed...I'll have to look into that.






-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Alexandre Benson
Smith
Sent: Tuesday, January 17, 2006 4:26 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Missing data


Raith, Daniel wrote:

>I have a strange situation with one customer. Basically out of 15
>users, all records in all tables for this one user, for the whole
>morning have gone missing for one specific day. They perform nightly
>backups, but I don't see how that could have done anything without
>affecting more than one users data. I've verified that she did in fact
>work that morning because in our old paradox tables, there are records
>of that users activity that morning. We use delphi6, dbexpress,
>firebird 1.5.2.4731, super server install. I don't know what their
>hardware is nor the OS on the firebird server.
>
>Just curious if anyone else has seen something like this or have
>possible ideas on how it might have happened.
>
>Daniel
>
>
>

Lookslike a rolled back transaction.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br