Table events not firing

[aschone]

While working in a master database I want to copy record changes to an external table (i.e. a table in a different database). In the database that holds the external table I have established record level events to perform audit trails.

When I copy my record to the external table I use table.open() to grab the table, then I use the Property_from_string() to write the record. Then I close the table.

By modifying the record in this format the CanSaveRecord and CanDeleteRecord events are not executing. Is this because the table is part of an external database? Do table events only work if the table is included in the database?

[Finian Lennon]

Re: Table events not firing

I don't think it's a question of whether the table is part of the database or not, it's a question of what field rules are enforced when record entry/changes are made via xbasic on a table opened with the table.open command.

I hadn't checked this before but, even if a table is part of the database, the can save event, for example, does not fire when a record is opened and then changed via xbasic. If, on the other hand, you make the change interactively in the default browse, the event does fire. I guess that A5 considers the "Can" events to be part of the "ui" field rules which are not enforced during xbasic changes.

Take a look at "honor_field_rules" in the on-line help.

[aschone]

Re: Table events not firing

Thank you for pointing me in the direction to answer my question.

From my reading it appears that if I reference a table via

tbl1 = table.current()

Then the field rules may be honored.

If the table is opened via

tbl2 = table.open("some_table")

Then the field rules will not be honored.

So I guess that answers my original question. Is there a way that I can via xbasic force a table to fire its field rules when the table is opened via Table.open()? If not then I need to work out a different method to handle the audit log.


Just as an FYI I am using the

addin.run("audit_trail")

and

Addin.run("audit_trail_deleteRecord")

to perform auditing.

Is it possible to call the audit functions from outside of the field rules?

[Finian Lennon]

Re: Table events not firing

You'll have to make special provisions in xbasic each time you write to the table outside the gui.

One table in our app also has an extensive audit trail capability in field-rule based code. All processes that entail changes to that table (outside of the set based forms used for data entry) run similar code to keep the audit trail current.