Can I ask for more details:
1. What do you mean by overide the base?
2. How should I call the super procedure? (in the 4GL code window or
using "forward to procedure" option within 4GL?)
or maybe you have some working example that is passing some variable so
I can look at it?
I am also pasting below unanswered question from my previus post:
In conditions menu (BPM) there is an option:
"the specific field of the changed row is equal to the specific value"
We can change "the changed row" to the one the following:
the added row
the updated row
the deleted row
the changed row
an unchanged row
some row
all rows
What is the difference between - "the updated row" and "the changed
row"?
Grzegorz Szczepański
Dnia Fri, 29 Aug 2008 22:23:35 +0100
"Stephen Edginton" <stephene@...> napisał(a):
1. What do you mean by overide the base?
2. How should I call the super procedure? (in the 4GL code window or
using "forward to procedure" option within 4GL?)
or maybe you have some working example that is passing some variable so
I can look at it?
I am also pasting below unanswered question from my previus post:
In conditions menu (BPM) there is an option:
"the specific field of the changed row is equal to the specific value"
We can change "the changed row" to the one the following:
the added row
the updated row
the deleted row
the changed row
an unchanged row
some row
all rows
What is the difference between - "the updated row" and "the changed
row"?
Grzegorz Szczepański
Dnia Fri, 29 Aug 2008 22:23:35 +0100
"Stephen Edginton" <stephene@...> napisał(a):
> Use a pre processor directive to enable the post process and export
> in the post process.
>
> If you need to pass a variable etc, you can override the base
>
> Then call the super procedure if required.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of phoenix Sent: 29 August 2008 20:25
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] BPM Passing Varaible Value from Pre-Processing
> to Post-Processing
>
>
>
> Mark,
> CustID is know in both, pre and post process. But I don't need CustID,
> I need CustNum (you can change CustID, but you can't change CustNum
> which is unique index for customer).
>
> But you put very good question. In matter of fact, I don't need to do
> anything special in Pre-Processing, but until today I wasn't aware
> that I can aquire customer data in post processing. I can do this by
> searching in post processing rows where rowmod = "". Am I right?
>
> In conditions menu (BPM) there is an option:
> "the specific field of the changed row is equal to the specific value"
> We can change "the changed row" to the one the following:
> the added row
> the updated row
> the deleted row
> the changed row
> an unchanged row
> some row
> all rows
>
> What is the difference between - "the updated row" and "the changed
> row"?
>
> The whole scenario that I am trying to realize is:
> There is a 'set' of fields that I want to track; i.e. CustNum,
> Address1, Address2, Character01, etc. then
> IF New customer is added I want to export this set to file,
> and IF any of the fields within this set will be changed then I want
> to export to file the whole set again. If there will be a change in
> other fields which are not in the tracked set, then no action is
> required.
>
> Grzegorz Szczepański
>
> Dnia Fri, 29 Aug 2008 08:02:02 -0400
> "Mark Wonsil" <mark_wonsil@... <mailto:mark_wonsil%40yahoo.com>
> > napisał(a):
>
> > Hi Grzegorz,
> >
> > While passing a variable from the pre-process to the post-process is
> > an interesting problem in itself, what is the business problem that
> > you're trying to solve? What exactly are you trying to do with the
> > Customer record? Why can't all of your processing occur in the
> > Post-Process when you have the custnum? What are you doing in the
> > Pre-Process that won't be available in the Post-Process? Are they
> > really tied together?
> >
> > BTW, Isn't CustID known at both in the Pre-Process and Post-Process?
> >
> > Mark W.
> >
> > > -----Original Message-----
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com
> > > <mailto:vantage%40yahoogroups.com> ] On Behalf Of phoenix Sent:
> > > Friday, August 29, 2008 5:26 AM To: robertb_versa@...
> > > <mailto:robertb_versa%40yahoo.com> ; vantage@yahoogroups.com
> > > <mailto:vantage%40yahoogroups.com> Subject: Re: [Vantage] BPM
> > > Passing Varaible Value from Pre-Processing to Post-Processing
> > >
> > > Robert,
> > > you wrote that if I "...brought all the needed assemblies into
> > > your application(s) and added UD07 as an FKV or Subtable...". Why
> > > should I do this? if I am just want to use UD07 as place for
> > > temporary variable, so I will be using it only in 4GL/BPM. That's
> > > why I wrote that UD07 is just another table like customer and
> > > other tables.
> > >
> > > INSERT statement is a combination of few other statements...
> > > according to 4GL reference:
> > >
> > > "INSERT statement
> > > Creates a new database record, displays the initial values for the
> > > fields in the record, prompts
> > > for values of those fields, and assigns those values to the
> > > record. The INSERT statement is a combination of the following
> > > statements: CREATE Creates an empty record buffer.
> > > DISPLAY Moves the record from the record buffer into the screen
> > > buffer and displays the contents of the buffer on the screen.
> > > PROMPT-FOR Accepts input from the user, and puts that input into
> > > the screen buffer.
> > > ASSIGN Moves data from the screen buffer into the record buffer."
> > >
> > > My first try was to use INSERT but vantage gives me error message,
> > > then I replaced INSERT with CREATE and ASSIGN, but still the same
> > > error.
> > >
> > > Have you ever tried to insert a new row in UD or any other table
> > > in 4GL within vantage? if so then you can show me your piece of
> > > code.
> > >
> > > Grzegorz Szczepanski
> > >
> > > Dnia Thu, 28 Aug 2008 09:06:21 -0700 (PDT)
> > > Robert Brown <robertb_versa@...
> > > <mailto:robertb_versa%40yahoo.com>
> > > <mailto:robertb_versa%40yahoo.com> > napisał(a):
> > >
> > > > I'm not sure what you mean by "just another table in Vantage as
> > > > Customer"... It is just another table (but doesn't have anything
> > > > inherently to do with Customer).
> > > >
> > > > I agree that the CREATE & ASSIGN statements looks OK - but the
> > > > error message indicates otherwise.
> > > >
> > > > If you replace CREATE with INSERT, does it help?
> > > >
> > > > ...Maybe I'm comletely misinterpreting the error message... Is
> > > > it possible you are working on a db that has UD07 set
> > > > explicitly to read only?
> > > >
> > > > ????
> > > >
> > > > Rob
> > > > --- On Thu, 8/28/08, phoenix <phoenix_@...
> > > > <mailto:phoenix_%40wp.pl> <mailto:phoenix_%40wp.pl> >
> > > wrote:
> > > >
> > > > > From: phoenix <phoenix_@... <mailto:phoenix_%40wp.pl>
> > > > > <mailto:phoenix_%40wp.pl> > Subject: Re: [Vantage] BPM
> > > > > Passing Varaible Value from Pre-Processing to Post-Processing
> > > > > To: robertb_versa@...
> > > > > <mailto:robertb_versa%40yahoo.com>
> > > <mailto:robertb_versa%40yahoo.com>
> > > > > Date: Thursday, August 28, 2008, 11:15 AM
> > > > > Isn't it the UD07 just another table in Vantage as
> > > > > Customer?
> > > > > Isn't CREATE UD07 creating just one row in UD07?
> > > > >
> > > > > Grzegorz Szczepański
> > > > >
> > > > > Dnia Thu, 28 Aug 2008 07:39:00 -0700 (PDT)
> > > > > Robert Brown <robertb_versa@...
> > > > > <mailto:robertb_versa%40yahoo.com>
> > > <mailto:robertb_versa%40yahoo.com> > napisał(a):
> > > > >
> > > > > > If you've brought all the needed assemblies into
> > > > > your application(s)
> > > > > > and added UD07 as an FKV or Subtable, why would you
> > > > > attempt to add it
> > > > > > again from within a BPM?
> > > > > >
> > > > > > Your statements are trying to establish permanent
> > > > > relationships
> > > > > > within the db schema and the error message is
> > > > > correctly telling you
> > > > > > that you are not licensed to do so.
> > > > > >
> > > > > > You want to read data from UD07 - not CREATE a
> > > > > permanent db level
> > > > > > schema change.
> > > > > >
> > > > > > Rob
> > > > > >
> > > > > > --- On Thu, 8/28/08, phoenix <phoenix_@...
> > > > > > <mailto:phoenix_%40wp.pl>
> > > <mailto:phoenix_%40wp.pl> >
> > > > > wrote:
> > > > > >
> > > > > > > From: phoenix <phoenix_@... <mailto:phoenix_%40wp.pl>
> > > > > > > <mailto:phoenix_%40wp.pl> > Subject: Re: [Vantage] BPM
> > > > > > > Passing Varaible Value
> > > > > from
> > > > > > > Pre-Processing to Post-Processing To:
> > > > > vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > <mailto:vantage%40yahoogroups.com>
> > > > > > > Cc: "Robert Brown"
> > > > > <robertb_versa@... <mailto:robertb_versa%40yahoo.com>
> > > > > <mailto:robertb_versa%40yahoo.com> >
> > > > > > > Date: Thursday, August 28, 2008, 4:31 AM
> > > > > > > Robert,
> > > > > > > I was trying to do the 'worst case', as
> > > > > you
> > > > > > > adivced. Unfortunatelly I
> > > > > > > wasn't able to do this this way. When trying
> > > > > to use
> > > > > > > CREATE statement
> > > > > > > like below
> > > > > > >
> > > > > > > CREATE UD07.
> > > > > > > ASSIGN
> > > > > > > UD07.Key1 = ttCustomer.CustID.
> > > > > > >
> > > > > > > the following errors apears:
> > > > > > >
> > > > > > > The following application error was encountered:
> > > > > > > You may not compile programs that update the
> > > > > database in
> > > > > > > this version
> > > > > > > (490) **
> > > > > > >
> > > > > > > So still no way to pass value between
> > > > > pre-processing and
> > > > > > > post-processing. And I don't know even if
> > > > > above
> > > > > > > restriction is because
> > > > > > > of Vantage or because of limited Progress
> > > > > license.
> > > > > > >
> > > > > > > (I can use some of the already existing record
> > > > > and write
> > > > > > > data to UD
> > > > > > > Fields, but it makes the whole resolution very
> > > > > > > 'ugly').
> > > > > > >
> > > > > > > Grzegorz Szczepañski
> > > > > > >
> > > > > > > Dnia Mon, 25 Aug 2008 07:39:11 -0700 (PDT)
> > > > > > > Robert Brown <robertb_versa@...
> > > > > > > <mailto:robertb_versa%40yahoo.com>
> > > <mailto:robertb_versa%40yahoo.com> >
> > > > > napisaĹ(a):
> > > > > > >
> > > > > > > > Worst case: Save your variable value to an
> > > > > appropriate
> > > > > > > table ud field
> > > > > > > > in your preprocess and read it in your post
> > > > > process.
> > > > > > > >
> > > > > > > > --- On Sun, 8/24/08, phoenix
> > > > > <phoenix_@... <mailto:phoenix_%40wp.pl>
> > > > > <mailto:phoenix_%40wp.pl> >
> > > > > > > wrote:
> > > > > > > >
> > > > > > > > From: phoenix <phoenix_@...
> > > > > > > > <mailto:phoenix_%40wp.pl> <mailto:phoenix_%40wp.pl> >
> > > > > > > > Subject: [Vantage] BPM Passing Varaible
> > > > > Value from
> > > > > > > Pre-Processing to
> > > > > > > > Post-Processing To: vantage@yahoogroups.com
> > > > > > > > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > > > > > > Date: Sunday, August 24, 2008, 6:23 PM
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Is in any way to pass a Variable Value from
> > > > > > > Pre-Processing to
> > > > > > > > Post-Processing in BPM using 4GL?
> > > > > > > >
> > > > > > > > I need to write to file a CustNum, but when
> > > > > new
> > > > > > > customer is created
> > > > > > > > in Pre-Processing (and Base-Processing too)
> > > > > CustNum =
> > > > > > > 0.
> > > > > > > > It is <> 0 when progress writes data
> > > > > to
> > > > > > > database. Which is in
> > > > > > > > Post-Processing.
> > > > > > > >
> > > > > > > > Therefore I need to find a CustNum (in
> > > > > > > Post-Processing) having a
> > > > > > > > CustID (from Pre-Processing or
> > > > > Base-Processing) . This
> > > > > > > is the reason
> > > > > > > > why I need to pass a CustID from
> > > > > Pre-Processing to
> > > > > > > Post-Processing.
> > > > > > > >
> > > > > > > > I was trying to use DEFINE NEW SHARED GLOBAL
> > > > > VARIABLE,
> > > > > > > but it doesn't
> > > > > > > > work for me bacause Vantage is complain that
> > > > > I
> > > > > > > can't use such type of
> > > > > > > > variable inside a nest procedure.
> > > > > > > >
> > > > > > > > Grzegorz Szczepański
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > [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/>
> > > <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/linksYahoo
> > > <http://groups.yahoo.com/group/vantage/linksYahoo> !
> > > > > > > Groups Links
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > vantage-unsubscribe@yahoogroups.com
> > > > > > > > <mailto:vantage-unsubscribe%40yahoogroups.com>
> > > > > > > > <mailto:vantage-
> > > unsubscribe%40yahoogroups.com>
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>