Button to execute 4GL?

Another way of executing 4GL



In the form you would do a customization (triggered via button or field
change) that would insert a row into a UD table (you do a getanew. and then
an update providing the information to the BPM in the key fields, etc) so
the update would then trigger a BPM to kick off. The BPM is then set up to
execute 4GL code (or call an external procedure). In the BPM you need to
disable the triggers if you are inserting rows.

What is really nice about this is that you can use this to take care of more
complex queries than BAQ's or Crystal reports can handle. I did a proof of
concept, creating a BAQ report that looks at UD101 and UD101a (the child
table). The user would enter a part number (into an option for Key1), which
would trigger the insert into the UD101 table (inserting the Key1 value into
the UD101.Key1) which then triggers the BPM to populate data into the UD101a
(BOM information for example). When you run the report it pulls the data
that you inserted into the UD101/UD101a tables.

One of the nice things about taking complex queries down to the database
level is that the database can do recursive calls, so all of a sudden BOM's
become relatively simple.

--Sean



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Steven Gotschall
Sent: Thursday, October 15, 2009 1:51 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Button to execute 4GL?





The only way I have found to do this is to create the 4GL code in a .p file,
save it on the server, have the button on the form change the value of a
UDcheckbox on the form, and set up a BAM that will execute the 4GL .p file
when the state of the UDcheckbox changes. Kind of convoluted, but it works.

________________________________
From: pbparker <scrumbus@... <mailto:scrumbus%40gmail.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thu, October 15, 2009 1:32:56 PM
Subject: [Vantage] Button to execute 4GL?


Is it possible to create a button on a form that simply executes 4GL code? I
need to create a button that updates a value in the database directly as
opposed to manipulating something on the screen for Customers.

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





[Non-text portions of this message have been removed]
Is it possible to create a button on a form that simply executes 4GL code? I need to create a button that updates a value in the database directly as opposed to manipulating something on the screen for Customers.
The only way I have found to do this is to create the 4GL code in a .p file, save it on the server, have the button on the form change the value of a UDcheckbox on the form, and set up a BAM that will execute the 4GL .p file when the state of the UDcheckbox changes. Kind of convoluted, but it works.




________________________________
From: pbparker <scrumbus@...>
To: vantage@yahoogroups.com
Sent: Thu, October 15, 2009 1:32:56 PM
Subject: [Vantage] Button to execute 4GL?

Â
Is it possible to create a button on a form that simply executes 4GL code? I need to create a button that updates a value in the database directly as opposed to manipulating something on the screen for Customers.







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