Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 9 of 9 total
Thread EDB2 : can i open a table without to have a Database in EDB MANAGER ?
Tue, Sep 2 2008 10:14 AMPermanent Link

"Mauro Botta"
Hi

i have a big application  , work on network , not C/S.

situation :

1) Much Table in X:\MYPROG\DATABASE\
2) one table in C:\Users\USER_NAME\AppData\Roaming\Society\MyProg\

for tables in point 1 , i have created in edb manager a Database.  ( ALL
OK )

for table in point 2 , i have a problem  ( user name directory... )

i need access at this table , WITHOUT created in edb manager a static
Database.
this path is different for any PC on network
i can't indicate a path for all pc in network.

i need write like this :

edbTable.DataBaseName :=
'C:\Users\USER_NAME\AppData\Roaming\Society\MyProg\'

but don't work.


hint ?
Tue, Sep 2 2008 11:21 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mauro


The way ElevateDB works is through the catalog. You can't just use a directory for the database as you could with DBISAM.

You have two options

1. Look at the users capability built into ElevateDB. You may be able to use this.
2. Create the database dynamically when the app starts.

Roy Lambert
Tue, Sep 2 2008 11:32 AMPermanent Link

"Mauro Botta"
>> 2. Create the database dynamically when the app starts.

but...

Can i have a PRIVATE DATABASE ( no  available on other pc ) ?  

( in BDE i was to create a Alias without save on disk )
Tue, Sep 2 2008 11:41 AMPermanent Link

"Mauro Botta"
>> 1. Look at the users capability built into ElevateDB. You may be able to
>> use this.

more info please ^^"
Tue, Sep 2 2008 12:23 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Mauro,

<< 1) Much Table in X:\MYPROG\DATABASE\
2) one table in C:\Users\USER_NAME\AppData\Roaming\Society\MyProg\

for tables in point 1 , i have created in edb manager a Database.  ( ALL
OK )

for table in point 2 , i have a problem  ( user name directory... )

i need access at this table , WITHOUT created in edb manager a static
Database. this path is different for any PC on network i can't indicate a
path for all pc in network. >>

You can do this, but you need to do two things:

1) Set the TEDBEngine property UseLocalSessionEngineSettings to True:

http://www.elevatesoft.com/manual?action=mancompprop&id=edb2&product=d&version=7&comp=TEDBEngine&prop=UseLocalSessionEngineSettings

2) Use a different session and configuration path for the access to the
local, private table.

You'll effectively then have two sessions in your application, one for
accessing the system-wide configuration path and databases, and one for
accessing the local, private configuration path and database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Sep 2 2008 1:37 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


But he still needs to create the database which is what (I think) he's trying to avoid. For the first 4 words I was wildly hopeful <vbg>


Roy Lambert
Tue, Sep 2 2008 1:37 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Mauro


Open the OLH in EDBManager, type users and select

Roy Lambert [Team Elevate]
Wed, Sep 3 2008 3:07 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< But he still needs to create the database which is what (I think) he's
trying to avoid. >>

You can't have a database in EDB without creating it first, and there's no
way to use a virtual configuration file at this time.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Sep 5 2008 1:04 AMPermanent Link

Richard Harding
Mauro,

Use 2 databases, the first database is in X:\MYPROG\DATABASE\

The second database can be created at run-time.  CREATE DATABASE <Name>  PATH <Path>  You
could get the path from the registry.

DROP the database (and keep the contents) when you close the application.

Any reason why that will not work?? ? ? ?


Richard Harding
Image