Can you allow a blank path to be specified in EDBManager for Alter Database please to allow for the occasions when someone wants the catalog & data in the same directory AND wants the app to be portable without having to reset the database path each time its loaded.

Roy Lambert

Roy,

<< Can you allow a blank path to be specified in EDBManager for Alter
Database please to allow for the occasions when someone wants the catalog &
data in the same directory AND wants the app to be portable without having
to reset the database path each time its loaded. >>

Just use '.'

Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Can you allow a blank path to be specified in EDBManager for Alter
>Database please to allow for the occasions when someone wants the catalog &
>data in the same directory AND wants the app to be portable without having
>to reset the database path each time its loaded. >>
>
>Just use '.'

Why didn't I think of that - just use DOS

Roy

Roy,

<< Why didn't I think of that - just use DOS >>

It's still there, like grandpa rocking away on the front porch.

Tim Young
Elevate Software
www.elevatesoft.com

On 9/07/2015 2:37 AM, Tim Young [Elevate Software] wrote:
> Roy,
>
> << Can you allow a blank path to be specified in EDBManager for Alter
> Database please to allow for the occasions when someone wants the
> catalog & data in the same directory AND wants the app to be portable
> without having to reset the database path each time its loaded. >>
>
> Just use '.'

I wasn't aware of this functionality. I wish I had know about this 2
years ago.

The program I am working on now has been designed without knowledge of
this functionality either...

To get around this perceived problem I had to create a function in my
installer and provide an executable that gets called from the installer,
that runs multiple times, each time setting the path for a different
database.

Is this functionality mentioned somewhere in the manual?

Regards,
  Peter Evans

Peter


>Is this functionality mentioned somewhere in the manual?

I don't think its mentioned explicitly, but I can find this

<<Note
As of 2.03 Build 14, if you specify a relative path for an on-disk (not in-memory) database, the
relative path will be interpreted as relative to the current configuration file path setting for the
current session. For example, given a configuration file path of 'C:\MyApplication', the database
path 'MyDatabase' will be interpreted as 'C:\MyApplication\MyDatabase'.>>


and . and .. are part of the relative path

But I do feel your pain

Roy Lambert

On 7/14/2015 12:30 AM, Peter Evans wrote:
> Is this functionality mentioned somewhere in the manual?

I doubt it - "." is a valid OS path (and docs do say "Any valid
operating system path").  Would be nice as a note in the docs (i know
we've been using "." with dbsrvr for long time).

Relative path for databases has been supported since 2.03 b14 so only
since then could you have used this.

I personally don't like mixing the catalog and db files in same folder
and like named folder for each db (still relative to catalog though).

Raul

Peter,

<< Is this functionality mentioned somewhere in the manual? >>

Yes, it's mentioned in the CREATE DATABASE statement help:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=CREATE_DATABASE

Tim Young
Elevate Software
www.elevatesoft.com

On 15/07/2015 6:40 AM, Tim Young [Elevate Software] wrote:
>
> << Is this functionality mentioned somewhere in the manual? >>
>
> Yes, it's mentioned in the CREATE DATABASE statement help:
>


If I alter the text in the manual to the case of dot, is the following
correct?

As of 2.03 Build 14, if you specify a relative path for an on-disk (not
in-memory) database, the relative path will be interpreted as relative
to the current configuration file path setting for the current session.
For example, given a configuration file path of 'C:\MyApplication', the
database path '.' will be interpreted as 'C:\MyApplication'.

Regards,
  Peter Evans

Peter,

<< If I alter the text in the manual to the case of dot, is the following
correct? >>

Yes.

Tim Young
Elevate Software
www.elevatesoft.com