[Answers] Trigger

[josipradnik]

Lianja does support CREATE TRIGGER. One thing to note - do not use double-quotes ("") within the AS <expression>, use single-quotes ('') or square brackets ([]) for strings.
In addition to the Visual FoxPro FOR DELETE | INSERT | UPDATE Triggers, Lianja supports additional Triggers 'after' operations: FOR DELETE | ONAFTERDELETE | INSERT | ONAFTERINSERT | UPDATE | ONAFTERUPDATE (http://www.lianja.com/doc/index.php/CREATE_TRIGGER).
You can also write trigger procedures within the Data Workspace:



Note that in the Data Workspace, Triggers are listed as onbeforeoperation and onafteroperation.

---

---

​All topics in [Answers] alphabetically:http://www.lianja.com/community/show...ll=1#post12352

[josipradnik]

Q:
In my "documenti" table, I've added a datetime field called "modified"
In the OnAfterUpdate trigger, i've wrote:

// Trigger onafterupdate for table documenti
replace documenti.modified with datetime()
return .t.

but work only if I open the table with Browse... not in section..
A:
If the trigger is being called, but the replaced value is being reset as you navigate, please try this:

// Trigger onafterupdate for table documenti
replace documenti.modified with datetime()
skip 0
return .t.

---

---

​All topics in [Answers] alphabetically:http://www.lianja.com/community/show...ll=1#post12352