Generate a change log entry with BAM 4GL executable?

Yahoo Archive
1
Yeah, you're right, I over thought and complicated it likely. The only method the user has to update the CheckBox01 field is by the button I created.

So, I easily created a Pre-Process BPM on Customer.Update and detected if CheckBox is going from false to true. Then actions were to set the values of the row to the same values the .p did, and it all works fine as well as creating change log entries.

I think I had it more complicated because initially I needed to update values and rows of tables not being accessed immediately by the Customer.Update but I've since simplified it to get it accomplished quicker.

--- In vantage@yahoogroups.com, Steven Gotschall <sgotschall@...> wrote:
>
> If the button does an Otrans.Update then I would think you could use the BPM update directive. All you would need is a way in the BPM to distinguish between the button update and a user save. But if the button is updating other fields then you could check one of those fields to see if it was set.
>
>
>
>
> ________________________________
> From: pbparker <scrumbus@...>
> To: vantage@yahoogroups.com
> Sent: Thu, October 22, 2009 10:29:25 AM
> Subject: [Vantage] Re: Generate a change log entry with BAM 4GL executable?
>
> Â
> Version 9. I have a custom button the user presses that executes code that toggles a custom checkbox on the screen (linked to CheckBox01 in the table) and then does a Otrans.Update.
>
> That custom checkbox value is monitored by a BAM that's set to execute a .p file on change. In turn that .p 4GL code updates a couple of database values in the Customer table and then sends an email.
>
> Not sure if I could accomplish this with BPM's being it's a button push.
>
> --- In vantage@yahoogroups .com, advantage@ . wrote:
> >
> > Are you on 8 or 9 Hmm not sure what your 4gl is doing. But I have set up BPMs where fields get updated and then set bams on those fields and have gotten history. But again its a BPM on a BO that fires?
> > Sent from my Verizon Wireless BlackBerry
> >
> > -----Original Message-----
> > From: "pbparker" <scrumbus@ .>
> > Date: Thu, 22 Oct 2009 13:57:58
> > To: <vantage@yahoogroups .com>
> > Subject: [Vantage] Re: Generate a change log entry with BAM 4GL executable?
> >
> > Unfortunately I already have BAM's set up on those fields and they're not firing when the 4GL executes against them. So, it would appear that change logs are triggered by the app logic itself and nothing in the database, which would make sense.
> >
> > Guess I'll see if I can find a way to enter a row in the table myself.
> >
> > --- In vantage@yahoogroups .com, advantage@ wrote:
> > >
> > > You should be able to set up a seperate bam changE log on those fields to show the history from/to on those fields
> > > Sent from my Verizon Wireless BlackBerry
> > >
> > > -----Original Message-----
> > > From: "pbparker" <scrumbus@>
> > > Date: Wed, 21 Oct 2009 20:36:14
> > > To: <vantage@yahoogroups .com>
> > > Subject: [Vantage] Generate a change log entry with BAM 4GL executable?
> > >
> > > So, I have a BAM executing a 4GL file that updates various Customer field values that the user doesn't have access to. i.e. They click a custom button and it sets the Credit Limit to 0.
> > >
> > > However, this method doesn't generate a change log entry with all the data that's changed, it only tracks the event field in the BAM that executed the 4GL.
> > >
> > > Is there a way within 4GL to generate or manually insert an entry into the change log for the record. I want to show show what the credit limit was before they kicked off the 4GL.
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
So, I have a BAM executing a 4GL file that updates various Customer field values that the user doesn't have access to. i.e. They click a custom button and it sets the Credit Limit to 0.

However, this method doesn't generate a change log entry with all the data that's changed, it only tracks the event field in the BAM that executed the 4GL.

Is there a way within 4GL to generate or manually insert an entry into the change log for the record. I want to show show what the credit limit was before they kicked off the 4GL.
3
You should be able to set up a seperate bam changE log on those fields to show the history from/to on those fields
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "pbparker" <scrumbus@...>
Date: Wed, 21 Oct 2009 20:36:14
To: <vantage@yahoogroups.com>
Subject: [Vantage] Generate a change log entry with BAM 4GL executable?

So, I have a BAM executing a 4GL file that updates various Customer field values that the user doesn't have access to. i.e. They click a custom button and it sets the Credit Limit to 0.

However, this method doesn't generate a change log entry with all the data that's changed, it only tracks the event field in the BAM that executed the 4GL.

Is there a way within 4GL to generate or manually insert an entry into the change log for the record. I want to show show what the credit limit was before they kicked off the 4GL.




[Non-text portions of this message have been removed]
4
Unfortunately I already have BAM's set up on those fields and they're not firing when the 4GL executes against them. So, it would appear that change logs are triggered by the app logic itself and nothing in the database, which would make sense.

Guess I'll see if I can find a way to enter a row in the table myself.

--- In vantage@yahoogroups.com, advantage@... wrote:
>
> You should be able to set up a seperate bam changE log on those fields to show the history from/to on those fields
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@...>
> Date: Wed, 21 Oct 2009 20:36:14
> To: <vantage@yahoogroups.com>
> Subject: [Vantage] Generate a change log entry with BAM 4GL executable?
>
> So, I have a BAM executing a 4GL file that updates various Customer field values that the user doesn't have access to. i.e. They click a custom button and it sets the Credit Limit to 0.
>
> However, this method doesn't generate a change log entry with all the data that's changed, it only tracks the event field in the BAM that executed the 4GL.
>
> Is there a way within 4GL to generate or manually insert an entry into the change log for the record. I want to show show what the credit limit was before they kicked off the 4GL.
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
I found out last week from support that a BAM 4GL may or may not run if
you are running BPM on the same process/table.

The BAM 4GL code is sometimes skipped.



Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner



RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pbparker
Sent: Thursday, October 22, 2009 8:58 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Generate a change log entry with BAM 4GL
executable?





Unfortunately I already have BAM's set up on those fields and they're
not firing when the 4GL executes against them. So, it would appear that
change logs are triggered by the app logic itself and nothing in the
database, which would make sense.

Guess I'll see if I can find a way to enter a row in the table myself.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
advantage@... wrote:
>
> You should be able to set up a seperate bam changE log on those fields
to show the history from/to on those fields
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@...>
> Date: Wed, 21 Oct 2009 20:36:14
> To: <vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> >
> Subject: [Vantage] Generate a change log entry with BAM 4GL
executable?
>
> So, I have a BAM executing a 4GL file that updates various Customer
field values that the user doesn't have access to. i.e. They click a
custom button and it sets the Credit Limit to 0.
>
> However, this method doesn't generate a change log entry with all the
data that's changed, it only tracks the event field in the BAM that
executed the 4GL.
>
> Is there a way within 4GL to generate or manually insert an entry into
the change log for the record. I want to show show what the credit limit
was before they kicked off the 4GL.
>
>
>
>
> [Non-text portions of this message have been removed]
>




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
6
Are you on 8 or 9 Hmm not sure what your 4gl is doing. But I have set up BPMs where fields get updated and then set bams on those fields and have gotten history. But again its a BPM on a BO that fires?
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "pbparker" <scrumbus@...>
Date: Thu, 22 Oct 2009 13:57:58
To: <vantage@yahoogroups.com>
Subject: [Vantage] Re: Generate a change log entry with BAM 4GL executable?

Unfortunately I already have BAM's set up on those fields and they're not firing when the 4GL executes against them. So, it would appear that change logs are triggered by the app logic itself and nothing in the database, which would make sense.

Guess I'll see if I can find a way to enter a row in the table myself.

--- In vantage@yahoogroups.com, advantage@... wrote:
>
> You should be able to set up a seperate bam changE log on those fields to show the history from/to on those fields
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@...>
> Date: Wed, 21 Oct 2009 20:36:14
> To: <vantage@yahoogroups.com>
> Subject: [Vantage] Generate a change log entry with BAM 4GL executable?
>
> So, I have a BAM executing a 4GL file that updates various Customer field values that the user doesn't have access to. i.e. They click a custom button and it sets the Credit Limit to 0.
>
> However, this method doesn't generate a change log entry with all the data that's changed, it only tracks the event field in the BAM that executed the 4GL.
>
> Is there a way within 4GL to generate or manually insert an entry into the change log for the record. I want to show show what the credit limit was before they kicked off the 4GL.
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
Version 9. I have a custom button the user presses that executes code that toggles a custom checkbox on the screen (linked to CheckBox01 in the table) and then does a Otrans.Update.

That custom checkbox value is monitored by a BAM that's set to execute a .p file on change. In turn that .p 4GL code updates a couple of database values in the Customer table and then sends an email.

Not sure if I could accomplish this with BPM's being it's a button push.

--- In vantage@yahoogroups.com, advantage@... wrote:
>
> Are you on 8 or 9 Hmm not sure what your 4gl is doing. But I have set up BPMs where fields get updated and then set bams on those fields and have gotten history. But again its a BPM on a BO that fires?
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@...>
> Date: Thu, 22 Oct 2009 13:57:58
> To: <vantage@yahoogroups.com>
> Subject: [Vantage] Re: Generate a change log entry with BAM 4GL executable?
>
> Unfortunately I already have BAM's set up on those fields and they're not firing when the 4GL executes against them. So, it would appear that change logs are triggered by the app logic itself and nothing in the database, which would make sense.
>
> Guess I'll see if I can find a way to enter a row in the table myself.
>
> --- In vantage@yahoogroups.com, advantage@ wrote:
> >
> > You should be able to set up a seperate bam changE log on those fields to show the history from/to on those fields
> > Sent from my Verizon Wireless BlackBerry
> >
> > -----Original Message-----
> > From: "pbparker" <scrumbus@>
> > Date: Wed, 21 Oct 2009 20:36:14
> > To: <vantage@yahoogroups.com>
> > Subject: [Vantage] Generate a change log entry with BAM 4GL executable?
> >
> > So, I have a BAM executing a 4GL file that updates various Customer field values that the user doesn't have access to. i.e. They click a custom button and it sets the Credit Limit to 0.
> >
> > However, this method doesn't generate a change log entry with all the data that's changed, it only tracks the event field in the BAM that executed the 4GL.
> >
> > Is there a way within 4GL to generate or manually insert an entry into the change log for the record. I want to show show what the credit limit was before they kicked off the 4GL.
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
8
I also found out that autoprint doesn't work if you have 4gl code attached to the BAM. AutoPrint did work for me once I separated the 4gl code to fire on a separate BAM even though the table and the trigger were the same. Support said it was a known issue.

I sort of have the impression that combining logging, 4gl/email, and/or autoprinting on a single BAM is a hit or miss kind of thing. It may or may not work.

Â
I actually had an Epicor support person tell me it was dangerous to use the updatetablebuffer command in a BAM 4gl code. If that is true, they need to take the example out of the help file where they use the updatetablebuffer on a BAM 4gl code example. Personally, I don't think it is any more dangerous to use it in a BAM then any place else.

Â

________________________________
From: Dale Schuerman <dale.schuerman@...>
To: vantage@yahoogroups.com
Sent: Thu, October 22, 2009 10:22:54 AM
Subject: RE: [Vantage] Re: Generate a change log entry with BAM 4GL executable?

Â
I found out last week from support that a BAM 4GL may or may not run if
you are running BPM on the same process/table.

The BAM 4GL code is sometimes skipped.

Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@ ramsys.com
<BLOCKED::blocked: :mailto:dale.schuerman@ ramsys.com> (email)

http://www.ramsys com <BLOCKED::blocked: :http://www.ramsys com/>
(website)

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of pbparker
Sent: Thursday, October 22, 2009 8:58 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Generate a change log entry with BAM 4GL
executable?

Unfortunately I already have BAM's set up on those fields and they're
not firing when the 4GL executes against them. So, it would appear that
change logs are triggered by the app logic itself and nothing in the
database, which would make sense.

Guess I'll see if I can find a way to enter a row in the table myself.

--- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ,
advantage@.. . wrote:
>
> You should be able to set up a seperate bam changE log on those fields
to show the history from/to on those fields
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@.. .>
> Date: Wed, 21 Oct 2009 20:36:14
> To: <vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> >
> Subject: [Vantage] Generate a change log entry with BAM 4GL
executable?
>
> So, I have a BAM executing a 4GL file that updates various Customer
field values that the user doesn't have access to. i.e. They click a
custom button and it sets the Credit Limit to 0.
>
> However, this method doesn't generate a change log entry with all the
data that's changed, it only tracks the event field in the BAM that
executed the 4GL.
>
> Is there a way within 4GL to generate or manually insert an entry into
the change log for the record. I want to show show what the credit limit
was before they kicked off the 4GL.
>
>
>
>
> [Non-text portions of this message have been removed]
>

############ ######### ######### ######### ######### ######### ######### ######
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys com
############ ######### ######### ######### ######### ######### ######### ######

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







[Non-text portions of this message have been removed]
9
If the button does an Otrans.Update then I would think you could use the BPM update directive. All you would need is a way in the BPM to distinguish between the button update and a user save. But if the button is updating other fields then you could check one of those fields to see if it was set.




________________________________
From: pbparker <scrumbus@...>
To: vantage@yahoogroups.com
Sent: Thu, October 22, 2009 10:29:25 AM
Subject: [Vantage] Re: Generate a change log entry with BAM 4GL executable?

Â
Version 9. I have a custom button the user presses that executes code that toggles a custom checkbox on the screen (linked to CheckBox01 in the table) and then does a Otrans.Update.

That custom checkbox value is monitored by a BAM that's set to execute a .p file on change. In turn that .p 4GL code updates a couple of database values in the Customer table and then sends an email.

Not sure if I could accomplish this with BPM's being it's a button push.

--- In vantage@yahoogroups .com, advantage@.. . wrote:
>
> Are you on 8 or 9 Hmm not sure what your 4gl is doing. But I have set up BPMs where fields get updated and then set bams on those fields and have gotten history. But again its a BPM on a BO that fires?
> Sent from my Verizon Wireless BlackBerry
>
> -----Original Message-----
> From: "pbparker" <scrumbus@.. .>
> Date: Thu, 22 Oct 2009 13:57:58
> To: <vantage@yahoogroups .com>
> Subject: [Vantage] Re: Generate a change log entry with BAM 4GL executable?
>
> Unfortunately I already have BAM's set up on those fields and they're not firing when the 4GL executes against them. So, it would appear that change logs are triggered by the app logic itself and nothing in the database, which would make sense.
>
> Guess I'll see if I can find a way to enter a row in the table myself.
>
> --- In vantage@yahoogroups .com, advantage@ wrote:
> >
> > You should be able to set up a seperate bam changE log on those fields to show the history from/to on those fields
> > Sent from my Verizon Wireless BlackBerry
> >
> > -----Original Message-----
> > From: "pbparker" <scrumbus@>
> > Date: Wed, 21 Oct 2009 20:36:14
> > To: <vantage@yahoogroups .com>
> > Subject: [Vantage] Generate a change log entry with BAM 4GL executable?
> >
> > So, I have a BAM executing a 4GL file that updates various Customer field values that the user doesn't have access to. i.e. They click a custom button and it sets the Credit Limit to 0.
> >
> > However, this method doesn't generate a change log entry with all the data that's changed, it only tracks the event field in the BAM that executed the 4GL.
> >
> > Is there a way within 4GL to generate or manually insert an entry into the change log for the record. I want to show show what the credit limit was before they kicked off the 4GL.
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







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