I have a small program I wish to use to produce a pricelist grouped by Type
and I am unable to get the query to work.
I'm using Delphi 5 and BBISAM 3.
I have a table (Items) with databasename = .\Data and when I place the Query
on the form I can set the datasource to the table but I'm unable to set the
database name property.
Consequently when I try to add fields to the query I get the message "Table
doesn't Exist".
As this is the first time I've used a Query I would appreciate any help.
Thanks Kerry

Kerry,

<< I have a small program I wish to use to produce a pricelist grouped by
Type and I am unable to get the query to work. I'm using Delphi 5 and BBISAM
3.  I have a table (Items) with databasename = .\Data and when I place the
Query on the form I can set the datasource to the table but I'm unable to
set the database name property. Consequently when I try to add fields to the
query I get the message "Table doesn't Exist". >>

Use a full path instead of a relative path (.\).  Relative paths rely on the
application always running in the same working directory, which is not
always guaranteed.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Kerry Cain" <cooper@members.bordernet.com.au> wrote in message
news:47847F78-11CB-453E-9906-8AF201B99C71@news.elevatesoft.com...
>I have a small program I wish to use to produce a pricelist grouped by Type
>and I am unable to get the query to work.
> I'm using Delphi 5 and BBISAM 3.
> I have a table (Items) with databasename = .\Data and when I place the
> Query on the form I can set the datasource to the table but I'm unable to
> set the database name property.
> Consequently when I try to add fields to the query I get the message
> "Table doesn't Exist".
> As this is the first time I've used a Query I would appreciate any help.
> Thanks Kerry

Put a database component in your datamodule or form, then have all tables
and queries linked to that database. That way, you only have to deal with
the path one time.

Robert

>