Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Baffled on Basic Stores Usage |
Wed, Feb 3 2010 7:24 PM | Permanent Link |
"Terry Swiers" | 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) --------------------------------------- |
Thu, Feb 4 2010 2:49 AM | Permanent Link |
Uli Becker | 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 |
Thu, Feb 4 2010 12:11 PM | Permanent Link |
"Terry Swiers" | 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) --------------------------------------- |
Thu, Feb 4 2010 2:10 PM | Permanent Link |
Uli Becker | 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 |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |