Custom Tables in Vantage

> Has anyone tried to create their own custom table in Vantage
> through either an ODBC tool or Progress SQL Explorer?

ADDING OR MODIFYING PROGRESS DATA THROUGH ODBC WILL MESS THINGS UP.

In order to create your own tables, you need to spend roughly $4000-5000 on
Provision.

It is wise, as William said, to keep your tables in another database. You
need to make sure that none of your tables have the same name as current or
future database tables. A good way to insure this is to preceed the names
with a predefined set of characters, such as the company's initials, or "UD"

Thus far, we have elected not to purchase provision. Though we may do so in
the future, we've come to the conclusion that at this point in time its in
our best interest to optimise the way we view, extract, and utilize data
already within the database. Using a combination of 4GL, Visual Basic,
Excel, and Crystal Reports we've been able to begin this task. Once we feel
we've completed that phase, we may start automating data entry and create
external tables, though we may end up deciding to use MSDE or SQL server
instead of provision for our external tables, and ultimately sending
requests to epicor approved custom programming for automated data entry
programs related to existing tables.

Until I get my hands on a legal, free copy of the Vantage Source code, I
believe its in my best interest to do everything in my power to make sure my
progress code doesn't conflict with Epicor's, and that would mean not
writing to the database, at least not for now.

Any comments? I'm still pretty new at this and could use all the direction
I can get.

Thaddeus



-----Original Message-----
From: william [mailto:william@...]
Sent: Tuesday, October 16, 2001 9:41 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Custom Tables in Vantage


I would strongly advise against adding your own tables to the Vantage
data base. You can have future problems with upgrades, and schema
changes that Epicor may make. Much better to create your own Progress
database and put your custom tables there. This option also allows you
to have users connect to it, without granting the user access to the
Vantage database proper.

My $.02 cdn.

efkcon01@... wrote:
>
> Has anyone tried to create their own custom table in Vantage
> through either an ODBC tool or Progress SQL Explorer?
>
> If so, were you successful? And how were you able to determine
> the table was created - by using Progress SQL Explorer or by
> some other means?
>
> Any response would be greatly appreciated.
>
> Ed Kulbacki
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1

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/
Has anyone tried to create their own custom table in Vantage
through either an ODBC tool or Progress SQL Explorer?

If so, were you successful? And how were you able to determine
the table was created - by using Progress SQL Explorer or by
some other means?

Any response would be greatly appreciated.

Ed Kulbacki
I would strongly advise against adding your own tables to the Vantage
data base. You can have future problems with upgrades, and schema
changes that Epicor may make. Much better to create your own Progress
database and put your custom tables there. This option also allows you
to have users connect to it, without granting the user access to the
Vantage database proper.

My $.02 cdn.

efkcon01@... wrote:
>
> Has anyone tried to create their own custom table in Vantage
> through either an ODBC tool or Progress SQL Explorer?
>
> If so, were you successful? And how were you able to determine
> the table was created - by using Progress SQL Explorer or by
> some other means?
>
> Any response would be greatly appreciated.
>
> Ed Kulbacki
>
>
> 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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1
William

Here's a $2.00 cdn question. I have been seriously considering this
option of adding tables in a separate database that users would connect to,
either as they connect to Vantage, or even better like you mention, without
connecting to Vantage. A question I have is how do you log on to this
separate database, do you need a mainmenu, does it need menus and DFs
loaded, that sort of thing. If you would be willing to provide some more
detail on this option, I think we could all benefit from it, as more and
more we tend to try to build our own specific tools. I'm not knowledgeable
enough in Progress programming to do the fancy stuff Lonnie Drew can do ( I
was very impressed !), but I did create a database, no tables for the
moment, and am not sure how I can access it.

Thanks

You can reply off-list if you prefer.

Richard Lafortune
IT manager
richardl@...


-----Message d'origine-----
De : william [mailto:william@...]
Envoye : Tuesday, October 16, 2001 10:41 PM
A : vantage@yahoogroups.com
Objet : Re: [Vantage] Custom Tables in Vantage


I would strongly advise against adding your own tables to the Vantage
data base. You can have future problems with upgrades, and schema
changes that Epicor may make. Much better to create your own Progress
database and put your custom tables there. This option also allows you
to have users connect to it, without granting the user access to the
Vantage database proper.

My $.02 cdn.