End User Error

rbuser

Environment:
- Delphi 5,
- RB Enterprise 6.03
- Windows 2000
- Advantage Database Server 6.2
- Netware 5.1

Getting following error message when attempting to run report
from Report Explorer or trying to modify report in DATA tab.

"Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record."

This happens in Windows 2000, but same report has no problems running
under Windows 98.

Any ideas?

Thanks,

Ron Marx
Programmer Analyst
CFMC


--
--
Sender and recipient of this message agree that no contract or
modification of any contract
is created by this electronic communication and that the provisions of
the Uniform Electronic
Transactions Act do not apply to any electronic transmissions received
by or sent to
CFMC.

digitalmetaphors

Was the data locked by the user? Did another user delete the record? It
sounds as if the Advantage connection is closed, giving you a BOF, EOF data
error. Is it timing out? Can the machine connect to the data on a DBGrid on
a form without RB involved?

Without using the report explorer, can you load a report using the
Report.Template.LoadFromDatabase method and print this report on the
problematic Win2K machine?


Cheers,

Jim Bennett
Digital Metaphors

rbuser

> Was the data locked by the user?
No.

No.

No.

involved?
Yes.

This end user query app was working just fine on a Win98 machine. Now it
won't work on a Win2K machine. I'm using a RB data dictionary as well as
an Advantage data dictionary. It is either a problem with the Advantage
OLE DB driver or RB. The report will run in the preview screen from
within the report designer.

Ron Marx

digitalmetaphors

We have had no problems using Advantage on our Win 2K and XP machines. Can
you test with RB 7.02 trial to see if the problem goes away? If that doesn't
help, then can you send a simple example to support@digital-metaphors.com
and we'll test with our Advantage server here in RB 7.02 on our Win2K
machines.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

I'm using an ADS data dictionary with my end user app. I can connect to
it with an ADO Connection component. My understanding is that I have to
use (ADO ala OLE DB Provider) to be able to use DADE in RB. If I open
the RB data dictionary builder and try to generate fields for it, I get
the same error message. I cannot use ADS Session in DADE because the
query wizard doesn't see the tables in the ADS data dictionary. The RB
data dictionary builder does work with ADS Session though.

This all worked fine under Win98, but Win2K seems to be a problem. We
are going to be upgrading soon to Delphi 7 and RB 7.02, so maybe that
will help. There is obviously some incompatibility here.

Thanks,

Ron Marx

digitalmetaphors

Try using the aliases in the ADS.ini file to setup a connection to ADS. That
way you don't have to use the OLE DB provider. The ADS alias support should
be what you use with the Advantage DADE plugin.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Jim,

That works as long as you don't use the ADS data dictionary. Once you
use it, the DADE no longer works to query data (error). Only ADO OLE DB
Provider will accomplish that until I upgraded to Win2K. Why I don't
know. I checked the MDAC version on both machines (Win2K v2.7, Win98
v2.5). I will also consult with Extended Systems because something is
wrong here.

Thanks,

Ron Marx

digitalmetaphors

The latest DADE plugin for RB 7.02 includes support for the Advantage data
dictionary. Try RB 7.02 trial edition to evaluate upgrading to the latest.


Cheers,

Jim Bennett
Digital Metaphors