Base 6.2.8.2 with embedded Firebird - Triggers?

[jjz]

Using LO 6.2.8.2 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
AS
BEGIN
DateChanged = current_timestamp;
END^
SET TERM ; ^

The Tools-SQL interface reports that the Token TERM is unknown.

[Ratslinger]

Hello,

Yes you can use Triggers. You cannot enter these via the Query section. Instead you must use from the menu Tools->SQL for entry.

This may be overkill based upon question. If may be better to state what problem you are having with default dates and resolve that. Depending on the situation, it may be better to set the default in the table itself. Need more information if you wish to pursue.

Edit:

When creating a trigger with Base SET TERM is not used. This should work:

CREATE TRIGGER clients_tmstmp FOR "Clients"
ACTIVE BEFORE INSERT OR UPDATE POSITION 0
AS
BEGIN
new."DateChanged" = current_timestamp;
END

With mixed case names you need to surround with quotes.

[jjz]

That did work. Thanks, Ratslinger. You are the fountain of knowledge.