Hello
I read the FAQ that tell I have to use alter database so I can changes
so I created a new fold in c:\ drive and copy all files and change the
path with the database manager but I did not find the tables I created !!

I return to previous folder still can see the tables I created !!

What I should ?

I hope you come in better solution for changing the database path.

Thanks

Isaac,

<< I read the FAQ that tell I have to use alter database so I can changes so
I created a new fold in c:\ drive and copy all files and change the path
with the database manager but I did not find the tables I created !! >>

You probably didn't copy the edbdatabase.edbcat catalog file also.  You need
to copy this database catalog file to the new folder also or the tables will
not be visible since the database catalog determines whether the tables
"exist" or not, not the table files themselves.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
>
> You probably didn't copy the edbdatabase.edbcat catalog file also.  You need
> to copy this database catalog file to the new folder also or the tables will
> not be visible since the database catalog determines whether the tables
> "exist" or not, not the table files themselves.
>
- ok but I am almost sure I copied all files, but in case I copied a
wrong file and the original file deleted "accidentally" - is there a way
to get the table back to the database ?

- What I should do so any user can move the application data and still
able to open the database and work on the application ?

Thanks

Isaac,

<< - ok but I am almost sure I copied all files, but in case I copied a
wrong file and the original file deleted "accidentally" - is there a way to
get the table back to the database ? >>

If you delete the catalog, then the only way to get access to the data again
is to restore a backup.  I could rebuild the catalog for you to match the
tables again, but I would have to charge you for this because it would take
literally hours to reset all of the object IDs and version numbers so that
they match properly.

<< What I should do so any user can move the application data and still able
to open the database and work on the application ? >>

Make sure to copy the catalog over also, and make sure that you have a good
backup because if you're allowing users to copy around database files,
they'll most definitely accidentally delete something important in the
process.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:
>
> Make sure to copy the catalog over also, and make sure that you have a good
> backup because if you're allowing users to copy around database files,
> they'll most definitely accidentally delete something important in the
> process.
>
It is common for application to be moved by users however,
what about the alter database ? should I use it ? if so when I should
use it for example in every application start up ?

Isaac,

<< It is common for application to be moved by users however, >>

Really ?  Most applications don't respond very well when they are moved
around manually by just copying their files.

<< what about the alter database ? should I use it ? >>

Sure, it does what it is supposed to do - alter the database information.

<< if so when I should use it for example in every application start up ? >>

That's up to you, but I would only use an ALTER DATABASE statement if the
database path is *not* correct.  You can find this out by querying the
Databases table in the system Configuration database:

http://www.elevatesoft.com/manual?action=mantopic&id=edb2&product=d&version=7&category=4&topic=13
http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=55

Just check the Path column for the desired database against the path that
you expect it to be at, and if the two don't match, use an ALTER DATABASE
statement to modify the path for the database.

--
Tim Young
Elevate Software
www.elevatesoft.com

Isaac


>It is common for application to be moved by users however,

I don't know a lot of multi-user database applications where the application and its data are moved around much. Even for single user stuff its more normal for it to sit still once its up and running. Its more normal for the application to be installed in a different location to which the developer used. Is that what you're talking about? If so do you provide data as part of the installation?

Roy Lambert [Team Elevate]

Tim Young [Elevate Software] wrote:
> Isaac,
>
> << It is common for application to be moved by users however, >>
>
> Really ?  Most applications don't respond very well when they are moved
> around manually by just copying their files.
>
> << what about the alter database ? should I use it ? >>
>
> Sure, it does what it is supposed to do - alter the database information.
>
> << if so when I should use it for example in every application start up ? >>
>
> That's up to you, but I would only use an ALTER DATABASE statement if the
> database path is *not* correct.  You can find this out by querying the
> Databases table in the system Configuration database:
>
> http://www.elevatesoft.com/manual?action=mantopic&id=edb2&product=d&version=7&category=4&topic=13
> http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=3&topic=55
>
> Just check the Path column for the desired database against the path that
> you expect it to be at, and if the two don't match, use an ALTER DATABASE
> statement to modify the path for the database.
>

ok - it is required from me to make the application portable in fact
this why I am using elevatedb otherwise I would go for oracle , the
data is shipped with the application so user may copy the application
any where
I hope as a feature request for this to be done automatically in future
releases

Thanks

Roy Lambert wrote:
>
If so do you provide data as part of the installation?
>
> Roy Lambert [Team Elevate]

Yes read my previous post

Thanks

Isaac

>ok - it is required from me to make the application portable in fact
>this why I am using elevatedb otherwise I would go for oracle , the
>data is shipped with the application so user may copy the application
>any where

That's not to difficult. I was thinking about a situation where the users were copying the data round as the mood took them. I'm guessing that your install program will all them you pick a directory into which the app goes and the data will either go into the same directory or a sub-directory (or if Vista is a target one of the allowed sub-directories eg Program Data). If so then assuming you've copied and installed the appropriate files on app start up use IncludeTrailingPathDelimiter(ExtractFilePath(Application.ExeName)); to get the "root" path, add your extension to it and use that to set the database path.

>I hope as a feature request for this to be done automatically in future
>releases

I wish I knew how that could be done, I could use it in a number of my apps but without a single file system holding the tables, catalog and preferably the program code I don't know how. Maybe Tim does but I'm not holding my breath <vbg>

Roy Lambert [Team Elevate]