Hi All,

I'm stumped on something that I thought I had down pat.  I've got the
following sample code that does nothing other than create a store, point to
it, get a list of the files in the store, and then delete the store.
ConnectionDM.Primary is a existing and open TEDBDatabase, and I've verified
that it is working correct with the database tables, and the c:\temp folder
does exist.   I have also verified via EDBManager that the store is being
created via a shared config file.

The code is throwing up on the select statement to get the list of files.


Q := TEDBQuery.Create(nil);
Q.SessionName := ConnectionDM.Primary.SessionName;
Q.DatabaseName := ConnectionDM.Primary.DatabaseName;

Q.SQL.Text := 'CREATE STORE "TestStore" AS LOCAL PATH ''C:\Temp'' ';
Q.ExecSQL;

Q.SQL.Text := 'SET FILES STORE to "TestStore"';
Q.ExecSQL;

Q.SQL.Text := 'select * from FILES';
Q.Open;  //<<<<<

Q.SQL.Text := 'DROP STORE "TestStore" KEEP CONTENTS';
Q.ExecSQL;
Q.Free;

The error message is "ElevateDB Error #700 An error was found in the
statement at line 1 and column 15 (ElevateDB Error #401 The table or view
FILES does not exist in the schema Default)."

Am I missing something really straight forward on this?

EDB 2.03b8 Unicode in Delphi 2009.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Terry,

> Q.SQL.Text := 'select * from FILES';
> Q.Open;  //<<<<<

It's in the configuration database. So this will be successful:

select * from configuration.files

Regards Uli

Uli,

> It's in the configuration database. So this will be successful:
>
> select * from configuration.files

Definitely missing the obvious.   Which explains why I was able to work
around the issue after posting by using session.execute.

The thing that threw me was that that same select statement would run from
EDB Manager so I thought I had to be doing something wrong.

Thanks for the assistance.

--

---------------------------------------
 Terry Swiers
 Millennium Software, Inc.
 http://www.1000years.com
 http://www.atrex.com

 Atrex Inventory Control/POS -
    Big business features without spending big business bucks!

Atrex Electronic Support Options:
 Atrex Knowledgebase: http://www.atrex.com/atrexkb.asp
 Email: mailto:support@atrex.com
 Newsgroup: news://news.1000years.com/millennium.atrex
 Fax: 1-925-829-1851
 Phone: 1-925-828-5892 (M-F, 9a-5p Pacific)
 ---------------------------------------

Terry,

> The thing that threw me was that that same select statement would run
from
> EDB Manager so I thought I had to be doing something wrong.

Most probably you had *not* selected a database in the treeview of
edbManager. If you select stores e.g. you are in the configuration database.

YBTW: ou can check that in the statusbar of edbManager. On the right
side you'll find a yellow database-icon, and its caption displays the
active database.

Regards Uli