Icon View Thread

The following is the text of the current message along with any replies.
Messages 21 to 23 of 23 total
Thread setting up a local application
Mon, May 7 2007 11:31 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< That was pretty much my understanding. Is there going to be a programming
tool for "clone database to another directory but not the data"? Or do we
just have to do a FileCopy (or whatever the DOS command is)? >>

For now you can just do a copy and then use a CREATE DATABASE statement to
set up the path to the database in the configuration.

<< Now I understand it its fine but to start with it was driving me round
the bend. Here I was creating the table in EDBMan and sometimes I couldn't
find it on disk. Its a major viewpoint switch from DBISAM. >>

Yes, it is.  But, it is also necessary. Smiley

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, May 7 2007 11:33 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< I now have the following setup:

EDBSession1.AutoSessionName - FALSE
EDBSession1.SessionType - stLocal
EDBSession1.SessionName - '' (empty: if I fill in 'Default' I get an error
that such a session already exists)
EDBSession1.LoginPassword - 'EDBDefault'
EDBSession1.LoginUser - 'Administrator'
EDBDatabase1.SessionName - ''
EDBDatabase1.Database - 'Test' (the databases are proper shown in the
propert editor's combobox) >>

Yep, the issue is that the SessionName properties are not populated.  You
need to make sure that you give the EDBSession1.SessionName property a
value, and then make sure that the EDBDatabase1 component, and all other
"lower-level" components, have their SessionName properties set to the same
value.

BTW, this was exactly the same requirement in DBISAM, so nothing has changed
in this respect with EDB.

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, May 7 2007 11:37 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Harry,

<< Well, I tried a lot of things so I'm not really sure but that easily
could be the case.  >>

Yep, Roy is correct - it was the case. Smiley

<< I am up and running now. One of these days I will try your "Ship the data
and the EDBDatabase.EDBCat in the same directory. All you need to do in your
app is create the config file and the database"  solution and I am on my way
(half of it really, still waiting for the middleware update that will work
with EDB. Will be a feast to see them working together- and a lot of testing
tooSmile Anyway, thanks a lot for helping out. >>

It's basically exactly as Roy indicates.  You ship the edbdatabase.edbcat
catalog file along with your table files, and install them in the desired
database directory.  Then you simply execute this statement using the
TEDBSession component:

with MyEDBSession do
  Execute('CREATE DATABASE "MyDatabase" PATH
'+Engine.QuotedSQLStr(DBInstallDir));

and that will create the database in the configuration so that it uses the
database directory where you installed the catalog and table files.   That's
all there is to it for a basic installation.

--
Tim Young
Elevate Software
www.elevatesoft.com

« Previous PagePage 3 of 3
Jump to Page:  1 2 3
Image