Board index » delphi » Calling Locate for one table posts changes in a second table

Darren Bedwell

Delphi Developer
Mon, 03 Dec 2001 03:00:00 GMT

Calling Locate for one table posts changes in a second table

I need to check if the information entered is valid before I post the
changes to my TTable.  To check this, I call locate on a different
table, but this prematurely posts the changes in the first table.  I
can't seem to pinpoint what is triggering the post.  There is no
master-detail relationship, neither table has an OnDataChange or
AfterScroll event handler, and when I step through the code (F7), it
skips straight to the BeforePost event of the table.  What are some
possible causes of this?

Thanks

 
Darren Bedwel

Delphi Developer
Mon, 03 Dec 2001 03:00:00 GMT

Re:Calling Locate for one table posts changes in a second table


I found the problem- the table I was calling Locate on had some lookup
fields defined that accessed the other table.
Quote
Darren Bedwell wrote:
> I need to check if the information entered is valid before I post the
> changes to my TTable.  To check this, I call locate on a different
> table, but this prematurely posts the changes in the first table.  I
> can't seem to pinpoint what is triggering the post.  There is no
> master-detail relationship, neither table has an OnDataChange or
> AfterScroll event handler, and when I step through the code (F7), it
> skips straight to the BeforePost event of the table.  What are some
> possible causes of this?

> Thanks

Other Threads

1. Does Table.Locate use index (2nd post)

2. How to use Table.Locate method for more than one fields search

3. Locate in Master/Detail tables causes Detail table to fail

4. Changing Tables with own Exception {2nd post}

5. Changes in Paradox table don't get posted

6. Posting record changes to a Foxpro table

7. Changing alias dir params not being seen by table (2nd post)

8. Delphi Keeps Changing Cursor Type - WHY???? (Second Post)

9. I don't get '...another user has changed the record'(second post)

10. todays date posted into a paradox table or interbase table