Board index » delphi » "At Beginning of Table" errors in TQuery

"At Beginning of Table" errors in TQuery

Can any one explain what this message might mean in the context of a
Live TQuery?  

Here is the scenario:
TQuery with RequestLive := TRUE and using Cached Records
1) Append new records to the Table
    This occurs OK
2) Immediatly attempt to change a value on the record
    This get the "At Beginning of Table" error.
3) Close and Open the TQuery and attempt the change again.
    This works OK.

What causes the "At Beginning of Table" message?

TIA for any help...

Mel
m...@cmtsys.com

 

Re:"At Beginning of Table" errors in TQuery


sounds to me like your cached records haven't been flushed to the database
yet when you try to edit the records.  They get flushed when you do the
close/open so you can then edit them... try the same thing with
cachedrecords off... see what happens....

Melvin R Rees <m...@cmtsys.com> wrote in message
news:376d64bb.104830918@news.uswest.net...

Quote
> Can any one explain what this message might mean in the context of a
> Live TQuery?

> Here is the scenario:
> TQuery with RequestLive := TRUE and using Cached Records
> 1) Append new records to the Table
>     This occurs OK
> 2) Immediatly attempt to change a value on the record
>     This get the "At Beginning of Table" error.
> 3) Close and Open the TQuery and attempt the change again.
>     This works OK.

> What causes the "At Beginning of Table" message?

> TIA for any help...

> Mel
> m...@cmtsys.com

Other Threads