Error message: either BOF or EOF is true etc.

Hi,

First of all thanks for all the excellent help!

I have a database with master detail tables, the detail tables are engined by an exported variable from the master table.
When I submit a SQL query which results in only one answer, sometimes no detail tables appear on the screen but the error message like written in the subject above arises, because there is no current record highlighted (the only record displayed: # is not highlighted). How can I solve this, because it doesn't happen all the time?

Regards,
Bart

Bart,
It sounds like maybe you need to do a dbReset.
This is necessary whenever your SQL changes.
See Programming Example D5a at:
http://www.aspdb.com
That may be all you need.
Mark.



------------
Bart van den Eijnden at 12/23/99 7:26:51 AM

Hi,

First of all thanks for all the excellent help!

I have a database with master detail tables, the detail tables are engined by an exported variable from the master table.
When I submit a SQL query which results in only one answer, sometimes no detail tables appear on the screen but the error message like written in the subject above arises, because there is no current record highlighted (the only record displayed: # is not highlighted). How can I solve this, because it doesn't happen all the time?

Regards,
Bart