Using DBISAM interface: Error: TdbMetaData.GetFieldsFromDataset...

rbuser

I am trying to use the daDBISAM.pas component to connect to a database
located on my local computer. Everything is connected correctly to a DBISAM
database. Name and DatabaseName are the same and the Session and database
type are set correctly also. When I use the query builder and after
retrieve a list of tables. When I select a table and press next I receive
this error:

TdbMetaData.GetFieldsFromDataset: Unable to open dataset: Employee

Employee is the table I selected. This table is accessable using a
tDBISAMTable connected to the same database and using DBSys. Any help would
be greatly appricated.

Thanks,

J. Michael Eubanks

rbuser

Michael,
Are you using a default session?

Jon

rbuser

Jon,

I tried it both ways, with the default session and using a session
component. I received the same error both times. I also tried connecting a
table to the database component, assigned to the same table. It made no
difference, the table component would open fine but still the same error
message. BTW, I am using DBISAM 3.10 and the newest RB. I also downloaded
and compiled the newest daDBISAM.pas on 7/20.

Thanks,

J. Michael Eubanks

digitalmetaphors

Have you tried to run the end user example? If so, did you encounter the
same problem with that? You can try clearing the metadata cache as shown
below.

--
Cheers,

Alexander Kramnik
Digital Metaphors

----------------------------------------
Tech Tip: Clearing the Meta Data Cache
----------------------------------------

There is a global meta data cache that the ReportBuilder uses to cache
information about the available database tables and fields. You can clear
the meta data cache using the following code.

uses
daMetaData;

begin
gMetaData.Clear;

end;

rbuser

Alexander,

I was able to eventually compile the end user example. I had to update the
daDBISAM.PAS with the one from Jon's web page and change the path of both
database components but after I did that the program did compile. I was also
able to access my data using the end user report builder. I didn't realize
that there were examples of the end user report builder code for the
different database engine. I definatly have somthing to go on now and I
think I can work it out from from here.


Thank you very much,

J. Michael Eubanks


"Alexander Kramnik (Digital Metaphors)" wrote