Custom database

Mark,

Thanks for the help! We'll give it a try.


Dave

-----Original Message-----
From: Mark Charamut [mailto:mrprogress@...]
Sent: Thursday, August 23, 2001 11:44 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Custom database


Dave,
Progress will search all connected databases for the table in
question. We have not found any issues where tables are not found. We do not
prefix any of our code with the database name. Optionally you can specify
the database name when you reference a table.
Find First CdsVntg.HRDays or Find First HRdays will do the same
thing as long as HRdays is not in two different databases.

Mark CharamutD

> -----Original Message-----
> From: Cole, Dave [mailto:dave@...]
> Sent: Thursday, August 23, 2001 12:17 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Custom database
>
>
> Mark,
>
> I was told by Progress support that if I used a separate
> database there
> could be problems when I reference tables. Progress will
> look for the table
> in the database that was opened first and if it doesn't find
> it there it
> might error out. Have you had any trouble with this?
>
> Thanks,
>
> Dave Cole
>
> -----Original Message-----
> From: Mark Charamut [mailto:mrprogress@...]
> Sent: Thursday, August 23, 2001 10:49 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Custom database
>
>
> If you add the objects into a new database there shouldn't be
> any need to
> get a custom dump and load routine. You will just need to
> make sure that you
> are only connected to the vantage database when you apply any schema
>
> ............................<Snip>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Do you need to encrypt all your online transactions? Secure
> corporate intranets? Authenticate your Web sites? Whatever
> security your site needs, you'll find the perfect solution here!
> http://us.click.yahoo.com/Bre3tC/Q56CAA/yigFAA/PhFolB/TM
<http://us.click.yahoo.com/Bre3tC/Q56CAA/yigFAA/PhFolB/TM>
> --------------------------------------------------------------
> -------~->
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> You must have already linked your email address to a yahoo id
> to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>


Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=207641.1565480.3121573.1269402/D=egroupweb/S=17050071
83:HM/A=765263/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>

<http://us.adserver.yahoo.com/l?M=207641.1565480.3121573.1269402/D=egroupmai
l/S=1705007183:HM/A=765263/rand=617722725>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Hi,

We are doing some custom Progress programming and have a question. We are
creating several new tables and would like to know if these tables should be
kept in a separate database or added to Vantage.db. We are going to add the
calls to our programs to the Vantage menu system.
If we set up a separate database, can we modify the Vantage.vtg file to open
this multiple database?
Are we better off adding the tables to the Vantage database making sure we
use unique table names. We could precede the name with "ud_" to show that
it is a user defined table.
I understand there are some issues with opening multiple databases.

Any help would be appreciated.


Thanks,


Dave



David S. Cole
Reeder & Kline



[Non-text portions of this message have been removed]
Dave,
Either method will work, but you'll get better response from Vantage Support
if you can assure them that your programs do not write AT ALL to the Vantage
database. Connecting to more that one database is a matter of creating the
entry in the services file and changing the .pf file. Here's an example:

-db x:\vantage\db\vantage.db
-N TCP -H servername -S service1name
-db x:\mydatabase\dbname.db
-N TCP -H servername -S service2name
-p x:\vantage\mainmenu.w

======================
Steve Sanders
Delta Centrifugal Corp
-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Wednesday, August 22, 2001 2:29 PM
To: Vantage@...
Subject: [Vantage] Custom database


Hi,

We are doing some custom Progress programming and have a question. We are
creating several new tables and would like to know if these tables should
be
kept in a separate database or added to Vantage.db. We are going to add
the
calls to our programs to the Vantage menu system.
If we set up a separate database, can we modify the Vantage.vtg file to
open
this multiple database?
Are we better off adding the tables to the Vantage database making sure we
use unique table names. We could precede the name with "ud_" to show that
it is a user defined table.
I understand there are some issues with opening multiple databases.

Any help would be appreciated.


Thanks,


Dave



David S. Cole
Reeder & Kline



[Non-text portions of this message have been removed]


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
Having worked with Progress for more years than I sometimes want to admit
and several different ERP packages such as Vantage, let me recommend the
following. DO NOT MODIFY THE STANDARD VANTAGE DATABASE even by adding
tables.

Keith E. Taylor
Vice President

LBSi
Information systems consulting
Specializing in Progress based ERP packages
Training, customization, programming and Business Consulting

12120 Elmwood Ave., Cleveland, OH 44111
Phone: 216-476-1416 ext 26
Fax: 216-476-1452
email: keith@...

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Wednesday, August 22, 2001 3:29 PM
To: eManfacturing Yahoo Groups (Vantage@...)
Subject: [Vantage] Custom database

Hi,

We are doing some custom Progress programming and have a question. We are
creating several new tables and would like to know if these tables should be
kept in a separate database or added to Vantage.db. We are going to add the
calls to our programs to the Vantage menu system.
If we set up a separate database, can we modify the Vantage.vtg file to open
this multiple database?
Are we better off adding the tables to the Vantage database making sure we
use unique table names. We could precede the name with "ud_" to show that
it is a user defined table.
I understand there are some issues with opening multiple databases.

Any help would be appreciated.


Thanks,


Dave



David S. Cole
Reeder & Kline



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


---------------------------
Long Business Systems, Inc.
12120 Elmwood Ave.
Cleveland, OH 44111
Phone: (216) 476-1416
Fax: (216) 476-1452
http://www.lbsi.com
---------------------------
Modifying the vantage database could severely hamper any future upgrades to
the database, and create billable support issues ESPECIALLY IF YOU ARE
ADDING TO OR MODIFYING THE TABLE STRUCTURE. Adding records to existing
vantage tables is one thing, but when you go to do patches, schema changes
etc. on a database with a different table structure than the patch program
expects, you could definitely run into issues.



-----Original Message-----
From: Keith Taylor [mailto:keith@...]
Sent: Wednesday, August 22, 2001 3:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Custom database


Having worked with Progress for more years than I sometimes want to admit
and several different ERP packages such as Vantage, let me recommend the
following. DO NOT MODIFY THE STANDARD VANTAGE DATABASE even by adding
tables.

Keith E. Taylor
Vice President

LBSi
Information systems consulting
Specializing in Progress based ERP packages
Training, customization, programming and Business Consulting

12120 Elmwood Ave., Cleveland, OH 44111
Phone: 216-476-1416 ext 26
Fax: 216-476-1452
email: keith@...

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Wednesday, August 22, 2001 3:29 PM
To: eManfacturing Yahoo Groups (Vantage@...)
Subject: [Vantage] Custom database

Hi,

We are doing some custom Progress programming and have a question. We are
creating several new tables and would like to know if these tables should be
kept in a separate database or added to Vantage.db. We are going to add the
calls to our programs to the Vantage menu system.
If we set up a separate database, can we modify the Vantage.vtg file to open
this multiple database?
Are we better off adding the tables to the Vantage database making sure we
use unique table names. We could precede the name with "ud_" to show that
it is a user defined table.
I understand there are some issues with opening multiple databases.

Any help would be appreciated.


Thanks,


Dave



David S. Cole
Reeder & Kline



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


---------------------------
Long Business Systems, Inc.
12120 Elmwood Ave.
Cleveland, OH 44111
Phone: (216) 476-1416
Fax: (216) 476-1452
http://www.lbsi.com
---------------------------



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
According to Vantage support, this is the best way to do it. As long as you
DO NOT CHANGE any Vantage tables or fields. We would use unique table names
that Vantage would most likely never use, such as preceding the table name
with "UD_" for User Defined.

According to support, the only issue with this is when you do an upgrade,
you would need to contact support for a custom file to do the dump and load
for the new schema changes.

Dave

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Thursday, August 23, 2001 9:57 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Custom database


Modifying the vantage database could severely hamper any future upgrades to
the database, and create billable support issues ESPECIALLY IF YOU ARE
ADDING TO OR MODIFYING THE TABLE STRUCTURE. Adding records to existing
vantage tables is one thing, but when you go to do patches, schema changes
etc. on a database with a different table structure than the patch program
expects, you could definitely run into issues.



-----Original Message-----
From: Keith Taylor [mailto:keith@...]
Sent: Wednesday, August 22, 2001 3:04 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Custom database


Having worked with Progress for more years than I sometimes want to admit
and several different ERP packages such as Vantage, let me recommend the
following. DO NOT MODIFY THE STANDARD VANTAGE DATABASE even by adding
tables.

Keith E. Taylor
Vice President

LBSi
Information systems consulting
Specializing in Progress based ERP packages
Training, customization, programming and Business Consulting

12120 Elmwood Ave., Cleveland, OH 44111
Phone: 216-476-1416 ext 26
Fax: 216-476-1452
email: keith@...

-----Original Message-----
From: Cole, Dave [mailto:dave@...]
Sent: Wednesday, August 22, 2001 3:29 PM
To: eManfacturing Yahoo Groups (Vantage@...)
Subject: [Vantage] Custom database

Hi,

We are doing some custom Progress programming and have a question. We are
creating several new tables and would like to know if these tables should be
kept in a separate database or added to Vantage.db. We are going to add the
calls to our programs to the Vantage menu system.
If we set up a separate database, can we modify the Vantage.vtg file to open
this multiple database?
Are we better off adding the tables to the Vantage database making sure we
use unique table names. We could precede the name with "ud_" to show that
it is a user defined table.
I understand there are some issues with opening multiple databases.

Any help would be appreciated.


Thanks,


Dave



David S. Cole
Reeder & Kline



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>


---------------------------
Long Business Systems, Inc.
12120 Elmwood Ave.
Cleveland, OH 44111
Phone: (216) 476-1416
Fax: (216) 476-1452
http://www.lbsi.com <http://www.lbsi.com>
---------------------------



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
998578890>

<http://us.adserver.yahoo.com/l?M=210949.1523302.3121208.1269402/D=egroupmai
l/S=1705007183:HM/A=763786/rand=497225634>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
If you add the objects into a new database there shouldn't be any need to
get a custom dump and load routine. You will just need to make sure that you
are only connected to the vantage database when you apply any schema
changes.

The only thing you will need to do with your database is to dump and load
the database tables and definitions into a database for the current version
of Progress.

I would also recommend that when adding tables to your own database that you
prefix them with a standard code to minimize the chances that your table
name will conflict with a table added in Vantage in a future release. We
have had Epicor use table names which were present in our database and it
caused a real headache.

Mark Charamut

President
Caesar Development Services, LLC
Epicor Authorized Independent Solution Provider
mcharamut@...
www.caesardev.com
(860) 667-3540




> -----Original Message-----
> From: Cole, Dave [mailto:dave@...]
> Sent: Thursday, August 23, 2001 11:08 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Custom database
>
>
> According to Vantage support, this is the best way to do it.
> As long as you
> DO NOT CHANGE any Vantage tables or fields. We would use
> unique table names
> that Vantage would most likely never use, such as preceding
> the table name
> with "UD_" for User Defined.
>
> According to support, the only issue with this is when you do
> an upgrade,
> you would need to contact support for a custom file to do the
> dump and load
> for the new schema changes.
>
> Dave
>
> -----Original Message-----
> From: Thad Jacobs [mailto:tjacobs@...]
> Sent: Thursday, August 23, 2001 9:57 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Custom database
>
>
> Modifying the vantage database could severely hamper any
> future upgrades to
> the database, and create billable support issues ESPECIALLY IF YOU ARE
> ADDING TO OR MODIFYING THE TABLE STRUCTURE. Adding records
> to existing
> vantage tables is one thing, but when you go to do patches,
> schema changes
> etc. on a database with a different table structure than the
> patch program
> expects, you could definitely run into issues.
>
>
>
> -----Original Message-----
> From: Keith Taylor [mailto:keith@...]
> Sent: Wednesday, August 22, 2001 3:04 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Custom database
>
>
> Having worked with Progress for more years than I sometimes
> want to admit
> and several different ERP packages such as Vantage, let me
> recommend the
> following. DO NOT MODIFY THE STANDARD VANTAGE DATABASE even by adding
> tables.
>
> Keith E. Taylor
> Vice President
>
> LBSi
> Information systems consulting
> Specializing in Progress based ERP packages
> Training, customization, programming and Business Consulting
>
> 12120 Elmwood Ave., Cleveland, OH 44111
> Phone: 216-476-1416 ext 26
> Fax: 216-476-1452
> email: keith@...
>
> -----Original Message-----
> From: Cole, Dave [mailto:dave@...]
> Sent: Wednesday, August 22, 2001 3:29 PM
> To: eManfacturing Yahoo Groups (Vantage@...)
> Subject: [Vantage] Custom database
>
> Hi,
>
> We are doing some custom Progress programming and have a
> question. We are
> creating several new tables and would like to know if these
> tables should be
> kept in a separate database or added to Vantage.db. We are
> going to add the
> calls to our programs to the Vantage menu system.
> If we set up a separate database, can we modify the
> Vantage.vtg file to open
> this multiple database?
> Are we better off adding the tables to the Vantage database
> making sure we
> use unique table names. We could precede the name with "ud_"
> to show that
> it is a user defined table.
> I understand there are some issues with opening multiple databases.
>
> Any help would be appreciated.
>
>
> Thanks,
>
>
> Dave
>
>
>
> David S. Cole
> Reeder & Kline
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
>
>
> ---------------------------
> Long Business Systems, Inc.
> 12120 Elmwood Ave.
> Cleveland, OH 44111
> Phone: (216) 476-1416
> Fax: (216) 476-1452
> http://www.lbsi.com <http://www.lbsi.com>
> ---------------------------
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> You must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
998578890>

<http://us.adserver.yahoo.com/l?M=210949.1523302.3121208.1269402/D=egroupmai
l/S=1705007183:HM/A=763786/rand=497225634>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Mark,

I was told by Progress support that if I used a separate database there
could be problems when I reference tables. Progress will look for the table
in the database that was opened first and if it doesn't find it there it
might error out. Have you had any trouble with this?

Thanks,

Dave Cole

-----Original Message-----
From: Mark Charamut [mailto:mrprogress@...]
Sent: Thursday, August 23, 2001 10:49 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Custom database


If you add the objects into a new database there shouldn't be any need to
get a custom dump and load routine. You will just need to make sure that you
are only connected to the vantage database when you apply any schema

............................<Snip>





[Non-text portions of this message have been removed]
Dave,
Progress will search all connected databases for the table in
question. We have not found any issues where tables are not found. We do not
prefix any of our code with the database name. Optionally you can specify
the database name when you reference a table.
Find First CdsVntg.HRDays or Find First HRdays will do the same
thing as long as HRdays is not in two different databases.

Mark CharamutD

> -----Original Message-----
> From: Cole, Dave [mailto:dave@...]
> Sent: Thursday, August 23, 2001 12:17 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Custom database
>
>
> Mark,
>
> I was told by Progress support that if I used a separate
> database there
> could be problems when I reference tables. Progress will
> look for the table
> in the database that was opened first and if it doesn't find
> it there it
> might error out. Have you had any trouble with this?
>
> Thanks,
>
> Dave Cole
>
> -----Original Message-----
> From: Mark Charamut [mailto:mrprogress@...]
> Sent: Thursday, August 23, 2001 10:49 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Custom database
>
>
> If you add the objects into a new database there shouldn't be
> any need to
> get a custom dump and load routine. You will just need to
> make sure that you
> are only connected to the vantage database when you apply any schema
>
> ............................<Snip>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Do you need to encrypt all your online transactions? Secure
> corporate intranets? Authenticate your Web sites? Whatever
> security your site needs, you'll find the perfect solution here!
> http://us.click.yahoo.com/Bre3tC/Q56CAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> You must have already linked your email address to a yahoo id
> to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/