Thank you for taking the time to read this post. I have a mutli-thread
application (Main thread and Working thread) both threads are using the same
database to Edit, Add or Delete records. Each thread is on a seperate
Session like suggested in Borland Documentation. My problem is that when I
close the application (most of the time) I lost records in the database.
Even records that have not been changed during the last session.

    It's not my first application in Delphi and it never happend to me
before. But it's the first time i'm using a thread to access a database.
There's maybe some rules I don't know and things that would be very
important to do in this particular case.

ANY help will be appreciated!

Sylvain Fortin
Computer Programmer

"Sylvain Fortin" <NoS...@sympatico.ca> schreef in bericht
news:Y2H57.947$jo4.190617@news20.bellglobal.com...

    I tried this configuration setting and it didn't change anything. I'm
still loosing records and I can't find any place in the application where
records can be deleted by the application itself. It is very strange cause
i'm not loosing only new records, I'm also loosing old records that haven't
been change during the application session.

If you have any other idea I'll be happy to try it, thank you very much for
your time.

Sylvain Fortin
Computer Programmer

*** Please Reply to Newsgroups ***

    Should I try to use only one session? What difference with it make, any
idea?

Thank You!

 Sylvain Fortin
 Computer Programmer

    Thank you for taking the time to help me =). I would like to know if
DbiSaveChanges is available in the Standard Version of Delphi. This is the
list of uses included in my Main Form:

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ToolWin, ComCtrls, StdCtrls, DBTables, Db, Buttons, ImgList,
  ExtCtrls, CommInt, inifiles, DBCtrls;

Also, I can't find find DbiSaveChanges in the help file, so I can't find in
wich library it is. Thank you very much and take care.

Sylvain Fortin
Computer Programmer

"Sylvain Fortin" <NoS...@sympatico.ca> schreef in bericht
news:rAB67.3589$eY6.105445@news20.bellglobal.com...

I think you have just given the answer to a similar problem I had a
few months back. I was using If UpdatesPending on a cached dataset to
test before ApplyUpdates/CommitUpdates. I found if I just changed the
data in one DBEdit control, then clicked the save button, the change
was not posted because the UpdatesPending property was false. Adding a
Post to the dataset before testing for UpdatesPending solved the
problem.

This technique might help for the problem in this thread.

    Thank you for taking time to answer my question again. I read your post
and i'll add the DBIProcs in my form uses. I hope it will solve my problem.
Only one thing, I read your explanation on your problem and I noticed that
you didn't have the same problem as I do. To answer 1 question, I'm using
TTable and it's the one giving me the problems and NO I'm not using any
DBControls. All my controls are regular Windows controls and I retrieve the
information they contain before each post and I make the changes using
MyTable.FieldByName("MyField").AsType := XXXXX. My problem is that I loose
records and not field updates. The application doesn't delete records by
itself you absolutely need human action to delete something and this
fonction is now hidden and known by me and 1 other person. But again, I'm
still loosing records. I even loose records that were not accessed during
the session.

    I'll try DbiSaveChanges like you told me to do, maybe it will fix my
problem. I really hope so cause I'm going nuts with this problem.

Thank you very much!