Programming - Progress version compatibility

Yahoo Archive
1
Wayne Cox wrote:

<snip>

> I see the prowin32 on the 3.0/8.3 server, but when I've tried doing writes
> with it, it says "may not compile programs that update the DB in this
> version." I guess spending the $$$ for Provision unlocks what's already
> there, and creates a couple icons?

Which means that the version of Progress you have installed is licensed as a
Query/Run version. You can compile programs the query the data base, but not
update it. You would need to upgrade the license for the database, but you would
not need to re-license Provision.

HTH

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

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

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985

X-Mozilla-Status: 0009 20:50:08 2001
X-Mozilla-Status: 0801
X-Mozilla-Status2: 00000000
FCC: /C|/Program Files/Netscape/Users/douglas/mail/Sent
Message-ID: <3AA836D0.23F6F664@...>
Date: Thu, 08 Mar 2001 20:50:08 -0500
From: William Colls <william@...>
X-Mozilla-Draft-Info: internal/draft; vcard=0; receipt=0; uuencode=0; html=0; linewidth=80
X-Mailer: Mozilla 4.72 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Programming - Provision
References: <A8C94E694FE9D2119D750008C733F6B112E050@...>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

We need to clarify a couple of things here.

Provision is a very powerful development tool that can be purchased to run with
Progress. The main point of Provision, and most of its cost, is tied to the
"object" like tools that are part of the set-up. It provides things like screen
design tools, SmartObjects and the ADM2 framework All are intended to make
development faster and more flexible, and once you spend the time and money to
learn the tool set they probably do help. Personally, I don't use them.

Bundled with provision is a Developer version of Progress, which allows you to
create programs that update the database. However, you can also buy a Developer
version of Progress without buying Provision. This tool allows you to create
programs that do update the data base. You don't get the fancy tools, but if you
don't plan any heavy duty development projects, you don't need Provision. The
Run/Query version of Progress that is usually supplied with Vantage also has a
basic development tool. Click Start>Programs>Progesss>Desktop, and there you
are. You have a tool to examine the Data Dictionary (icon looks like an open
book) and a source code editor(icon looks like a Pen and ink pot). Using this
basic tool you can build as fancy a Program as you want to, using all the neat
widgets that are part of the windows environment. Whether or not you can write
to the database depends on the version of the Progress Database Engine you have,
not the development tools that you are using.

If any one wants more information about this, please feel free to email me
directly.

Todd Caughey wrote:

> Pardon me if I split the "Programming - Progress version compatibility"
> thread into a side topic.
>
> OK, so what the heck is Provision and why should I need it? Obviously
> Epicor does not promote it but then they assume any Vantage site should
> never need to know anything about the database or Progress. Years of
> experience with other systems (longest was ASK-ManMan on Digital's DBMS
> database) tell me otherwise.
>
> How much does it cost or do I have it already and don't know it?
> Where can I get educated in both Progress and Provision?
> If I was able to get source code for Vantage what else would I need to
> self-maintain? Not that I want to...yet but maybe someday I will have to
> and I suspect I could not learn what I need in a few weeks. Now is the time
> to prepare.
>
> Thanks,
> -Todd Caughey
> Harvey Vogel Mfg. Co.
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
2
Hi All... Have a question about Progress version compatibility when trying
to write to the Vantage DB. I have Provision 9.0B loaded on my PC, and I'm
trying to update a field in our Vantage 3 (Progress 8.3) database. It
connects OK, and I can display data with a few lines on code from the
Procedure Editor.

But if I try to write to a table with a trigger, I get the error message
"Invalid version, 820 (Expected 908) in object file {vantage trg
path...} (2888)" Isn't the trigger code executed on the server
anyway? Is there a way around this problem, or do the versions have to be
an exact match?

-Thanks,
Wayne Cox
3
Depending on what you are trying to do... you could attempt
to override the trigger...

on write of part override do: end.

Put this before your code. Make sure you know what is going on
before you do an override though.

Wayne Cox wrote:
>
> Hi All... Have a question about Progress version compatibility when trying
> to write to the Vantage DB. I have Provision 9.0B loaded on my PC, and I'm
> trying to update a field in our Vantage 3 (Progress 8.3) database. It
> connects OK, and I can display data with a few lines on code from the
> Procedure Editor.
>
> But if I try to write to a table with a trigger, I get the error message
> "Invalid version, 820 (Expected 908) in object file {vantage trg
> path...} (2888)" Isn't the trigger code executed on the server
> anyway? Is there a way around this problem, or do the versions have to be
> an exact match?
>
> -Thanks,
> Wayne Cox
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
Triggers execute on the client side. Hence the error you are seeing. The work
around is as Joe suggested, but as he also notes, you run the risk of damaging
the data integrity of your database, unless you can determine exactly what the
trigger is doing.

If you have the source code, you could recompile the trigger, and place it in a
separate directory. Then by using the -trig start-up parameter you can point to
the directory where your V9 triggers are located.

Wayne Cox wrote:

> Hi All... Have a question about Progress version compatibility when trying
> to write to the Vantage DB. I have Provision 9.0B loaded on my PC, and I'm
> trying to update a field in our Vantage 3 (Progress 8.3) database. It
> connects OK, and I can display data with a few lines on code from the
> Procedure Editor.
>
> But if I try to write to a table with a trigger, I get the error message
> "Invalid version, 820 (Expected 908) in object file {vantage trg
> path...} (2888)" Isn't the trigger code executed on the server
> anyway? Is there a way around this problem, or do the versions have to be
> an exact match?
>
> -Thanks,
> Wayne Cox
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985
5
Am I missing something here? If you have a 3.0 db why not run provision from there?
It might take 30 seconds to create a shortcut (no install required). i.e.
x:\dlc\bin\prowin32.exe Sounds like you already know how to connect to the db so I
won't go into further detail. I am running 2 versions of provision as we speak,
never had any problems.



William Colls wrote:

> Triggers execute on the client side. Hence the error you are seeing. The work
> around is as Joe suggested, but as he also notes, you run the risk of damaging
> the data integrity of your database, unless you can determine exactly what the
> trigger is doing.
>
> If you have the source code, you could recompile the trigger, and place it in a
> separate directory. Then by using the -trig start-up parameter you can point to
> the directory where your V9 triggers are located.
>
> Wayne Cox wrote:
>
> > Hi All... Have a question about Progress version compatibility when trying
> > to write to the Vantage DB. I have Provision 9.0B loaded on my PC, and I'm
> > trying to update a field in our Vantage 3 (Progress 8.3) database. It
> > connects OK, and I can display data with a few lines on code from the
> > Procedure Editor.
> >
> > But if I try to write to a table with a trigger, I get the error message
> > "Invalid version, 820 (Expected 908) in object file {vantage trg
> > path...} (2888)" Isn't the trigger code executed on the server
> > anyway? Is there a way around this problem, or do the versions have to be
> > an exact match?
> >
> > -Thanks,
> > Wayne Cox
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
> --
> /* ============================================================== */
>
> William E. Colls Tel 613 591 0079
> PROComputer Systems Fax 613 591 3924
> 67 Willow Glen Dr www.procomsys.com
> Kanata Ontario Canada PEG Member 1998051404
>
> Specialists in Progress Software development since 1985
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
6
At 09:01 AM 3/8/2001 , you wrote:
>Am I missing something here?

Nope. That'd be me, I guess ;)

> If you have a 3.0 db why not run provision from there?
>It might take 30 seconds to create a shortcut (no install required). i.e.
>x:\dlc\bin\prowin32.exe Sounds like you already know how to connect to
>the db so I
>won't go into further detail. I am running 2 versions of provision as we
>speak,

I've been a programmer for most of the last 15 years. But am new to
Progress. We bought Vantage 1.5 years ago (and Provision w. it.) But
I've only scratched the surface on doing any real coding. I've largely
been stuck playing PC technician, network janitor, and report writer
through our implementation. I'm finally finding time to mess with the
development tools.

Anyway... directions from The List and Epicor said to install it locally
on the PC running it, which I did. It also needed a separate provision
installation code number for that. I thought we were moving to Vtg 4.0
soon, so opted for 9.0. Having multiple versions of one thing loaded
always concerns me, so it seemed preferable to make 9.0 work with my older DB.

I see the prowin32 on the 3.0/8.3 server, but when I've tried doing writes
with it, it says "may not compile programs that update the DB in this
version." I guess spending the $$$ for Provision unlocks what's already
there, and creates a couple icons?
7
Wayne Cox wrote:

<snip>

> I see the prowin32 on the 3.0/8.3 server, but when I've tried doing writes
> with it, it says "may not compile programs that update the DB in this
> version." I guess spending the $$$ for Provision unlocks what's already
> there, and creates a couple icons?

Which means that the version of Progress you have installed is licensed as a
Query/Run version. You can compile programs the query the data base, but not
update it. You would need to upgrade the license for the database, but you would
not need to re-license Provision.

HTH

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

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

William E. Colls Tel 613 591 0079
PROComputer Systems Fax 613 591 3924
67 Willow Glen Dr www.procomsys.com
Kanata Ontario Canada PEG Member 1998051404

Specialists in Progress Software development since 1985