topic Re: Table Maintenance Generator in Application Development and Automation Discussions

Table Maintenance Generator

VishwanathV — Tue, 03 Apr 2018 20:40:10 GMT

Hi,

If there exists a TMG for a custom table with few of its TMG events implemented for validation or auto-fill purposes then, how would these events be impacted when TMG needs to be regenerated in the following scenarios, i.e., when:

1. A new field is added to the custom table.

2. An existing field of the custom table is deleted, and the field has been referred to in one of those TMG events previously implemented.

Best Regards,

Vishwanath

Re: Table Maintenance Generator

former_member234832 — Tue, 03 Apr 2018 21:37:57 GMT

Hi Vishwanath,

AFAIK, the events of TMG will not be changed after any regeneration of the table.

However, as you interact with table data in events not directly, but via generic tables TOTAL and EXTRACT, the event code will not be affected.

But at the runtime, if some fields were changed or deleted, you probably will get a dump, when you will try to dynamically assign non-existent field.

To avoid it, always check after each assign operation, if it was done successful. And as a good practice process errors with a proper error message.

tl;dr:

1. new field - check if field sequence isn't used somehow, otherwise it will be ok;

2. change or delete - after regeneration event code will stay active, but dynamic assigns to changes or deleted fields will cause runtime errors.

Best regards,

Ilya

Re: Table Maintenance Generator

matt — Wed, 04 Apr 2018 06:54:45 GMT

Why not create a table quickly, and generate a table maintenance, and try it? Then write a blog about your experiences?