I thought I was finished migrating my application from DBISAM, but I think I just bumped into another issue.

My application can be installed to and run from a USB drive. The EDB configuration/catalog is stored on the USB drive, as well as any
databases. The databases and stores are created with the path based on the PC where the USB drive is connected. Obviously, this path
will probably be different (different drive letter at least) on a different computer.

Do I need to detect that the path is different and update the database? If so, how do I do that without stomping on the database tables
that already exist.

Thanks.

-David

David,

<< Do I need to detect that the path is different and update the database?
>>

Yes.

<< If so, how do I do that without stomping on the database tables that
already exist. >>

ALTER DATABASE and ALTER STORE will allow you to change the path without
touching the existing contents of the databases and stores.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

ALTER DATABASE and ALTER STORE will allow you to change the path without
touching the existing contents of the databases and stores.


I'll look into this. Thanks.

A followup question: What happens if the EDB configuration/databases is burned to a CDROM? Can the software still function, or is it
hosed?

Thanks.

-David

Dear Tim

> << Do I need to detect that the path is different and update the database?
>  >>
>
> Yes.

Why Yes ? Relative Path works too

--
Charalampos Michael - [Creation Power] - http://www.creationpower.gr

David,

<< A followup question: What happens if the EDB configuration/databases is
burned to a CDROM? Can the software still function, or is it hosed? >>

The software will still function if the drive letters are valid, but if they
are not then there won't be any way to change them since the configuration
file will be read-only.  I would only suggest putting a configuration file
on a CD-ROM in instances where you know for a fact that you will never need
to modify the configuration at all, i.e. the databases and stores referenced
in the configuration are on (and only on) the CD-ROM itself.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<< A followup question: What happens if the EDB configuration/databases is
burned to a CDROM? Can the software still function, or is it hosed? >>

The software will still function if the drive letters are valid, but if they
are not then there won't be any way to change them since the configuration
file will be read-only.  I would only suggest putting a configuration file
on a CD-ROM in instances where you know for a fact that you will never need
to modify the configuration at all, i.e. the databases and stores referenced
in the configuration are on (and only on) the CD-ROM itself.



Well...crap. That sucks.

No workaround at all? "Burn it and lose it" doesn't seem all that useful.

Fortunately, this isn't something I run into much. But it was a feature of DBISAM that I'm sorry to lose.

-David