Kbase P93127: Report Builder: How to execute the Table Interface Engine from the server as soon as a client adds
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/29/2004 |
|
Status: Unverified
GOAL:
Can the Report Builder Table Interface Engine execute a report on the server as soon as a client adds a new record to the RBREPORT table?
GOAL:
Report Builder Table Interface, aderb\_prore.p
GOAL:
Execute report on the server when a new record is added to the Table Interfaces' RBREPORT table.
GOAL:
How to get the Report Builder Report to execute on the server after a record is added to the Table Interface?
FACT(s) (Environment):
Progress 7.x
Progress 8.x
Progress 9.x
FIX:
There is no feature of the Report Builder Table Interface that can be used to accomplish this.
A database trigger will not work either, as it would still be executed on the client
The only way to accomplish this is to design the application similar to the following:
1. Add a field of a boolean datatype to the RBREPORT Table with an initial value of TRUE.
2. Have a 4gl server process continuously loop through the RBREPORT table. If it finds a record where this boolean field is True then execute the report. After the report is executed, set the boolean fields value to FALSE.