Hi
I try to create a simple local application following the cdCollector demo.
probably because something i missed  I stuck when I try to open the database
catalog.
"SELECT * FROM Information.Tables where ..."
The query doesn't return any value.
It's strange because on design mode I can see all the database table and
only during
run time the query is empty
Any suggestion ?
Sorin

Sorin


Have you linked the query to the data database or the configuration database?

Roy Lambert

> Have you linked the query to the data database or the configuration
> database?
>
> Roy Lambert

Yes the query DatabaseName is set to the Database  DatabaseName and
the Sessionname to the Session component SessionName and it's  work
The query is connected to a dbbgrid and if I activate it on the desing time
it's show all the tables list on the dbgrid.
Sorin

Sorin


Very silly question - are you sure the query is being executed at runtime?

Roy Lambert

Yes I check with the debbuger
it pass the Open method and RecordCount=0
sorin
> Very silly question - are you sure the query is being executed at runtime?
>
> Roy Lambert
>

Sorin,

<< It's strange because on design mode I can see all the database table and
only during run time the query is empty >>

This most likely means that you're changing the TEDBEngine.ConfigPath at
runtime, resulting in different database paths, etc. than what you're using
at design-time.

--
Tim Young
Elevate Software
www.elevatesoft.com

I set the path on OnCreate method
"EDBEngine.ConfigPath := ExtractFilePath(Application.ExeName)"
I try also to remove this line and live the path as defined on design time
but doesn't help
Sorin

>
> This most likely means that you're changing the TEDBEngine.ConfigPath at
> runtime, resulting in different database paths, etc. than what you're
> using at design-time.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Sorin,

<< I set the path on OnCreate method
"EDBEngine.ConfigPath := ExtractFilePath(Application.ExeName)"
I try also to remove this line and live the path as defined on design time
but doesn't help >>

Something is different in terms of your runtime environment vs. your
design-time environment, and the only thing that can cause different
database paths to exist is to use a different configuration path.

--
Tim Young
Elevate Software
www.elevatesoft.com

I'll recheck
but before i open the query to get the tables list I open a query
to check if the database exists, same as in your cdCollector demo,
and the result is positive. Isn't this an indication that the path is
correct?
Sorin

> Something is different in terms of your runtime environment vs. your
> design-time environment, and the only thing that can cause different
> database paths to exist is to use a different configuration path.
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Sorin,

<< I'll recheck but before i open the query to get the tables list I open a
query to check if the database exists, same as in your cdCollector demo, and
the result is positive. Isn't this an indication that the path is  correct?
>>

It indicates that the *logical* database exists in the catalog, but it
doesn't indicate that the path is the same as what you would expect or want.
Check the Path column in the Databases table to ensure that it is pointing
to where you think it should be pointing.

--
Tim Young
Elevate Software
www.elevatesoft.com