Using LO 220.127.116.11 with firebird embedded
Struggling with default dates in the forms, so I thought that using a trigger would be an easy solution.
But the sql parser does not accept the SET TERM statement. I assume this is because it is embedded and there is no central SQL/RDB engine with embedded?
Am I correct that I cannot use triggers and similar relation database functions with embedded firebird in LO Base?
Update to orig question:
Want to use a timestamp and have it automatically update when the row is changed. My understanding is that it requires a trigger as in other rdb systems.
I was using the Tools: SQL interface and attempting to execute the code to create a trigger:
SET TERM ^ ;
CREATE TRIGGER clients_tmstmp FOR Clients
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
DateChanged = current_timestamp;
SET TERM ; ^
The Tools-SQL interface reports that the Token TERM is unknown.