description: Add posibility to create timer objects - working like procedure and fire at specified time or interval
this can change some client applications to very "thin clients"
and i suppose many people can find better example of use

simple example :
create Timer DeleteOldData RUN_AT 12:30
as
BEGIN
DELETE FROM SOME_TABLE WHERE DATE_INSERT<CAST('now' AS TIMESTAMP) - 30;
END;

create Timer DeleteOldData RUN_INTERVAL 60*1000
as
DECLARE VARIABLE VAR_ID INTEGER;
DECLARE VARIABLE VAR_NAME VARCAHR(40);
DECLARE VARIABLE VAR_DT TIMESTAMP;
BEGIN
FOR SELECT
ID, NAME, DT
FROM
BUFFER
INTO :VAR_ID, :VAR_NAME, :VAR_DT
DO
BEGIN
UPDATE SOMETABLE SET LAST_ACCES=:VAR_DT WHERE NAME=:VAR_NAME;
DELETE FROM BUFFER WHERE ID=:VAR_ID;
END;
END;

=>

Add posibility to create timer objects - working like procedure and fire at specified time or interval
this can change some client applications to very "thin clients"
and i suppose many people can find better example of use

simple example :
create Timer DeleteOldData RUN_AT 12:30
as
BEGIN
DELETE FROM SOME_TABLE WHERE DATE_INSERT<CAST('now' AS DATE) - 30;
END;

create Timer DeleteOldData RUN_INTERVAL 60*1000
as
DECLARE VARIABLE VAR_ID INTEGER;
DECLARE VARIABLE VAR_NAME VARCAHR(40);
DECLARE VARIABLE VAR_DT TIMESTAMP;
BEGIN
FOR SELECT
ID, NAME, DT
FROM
BUFFER
INTO :VAR_ID, :VAR_NAME, :VAR_DT
DO
BEGIN
UPDATE SOMETABLE SET LAST_ACCES=:VAR_DT WHERE NAME=:VAR_NAME;
DELETE FROM BUFFER WHERE ID=:VAR_ID;
END;
END;

Link: This issue is duplicated by CORE4012 [ CORE4012 ]

Link: This issue is duplicated by CORE4052 [ CORE4052 ]

Link: This issue duplicates CORE1613 [ CORE1613 ]

Link: This issue duplicates CORE743 [ CORE743 ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

status: Resolved [ 5 ] => Closed [ 6 ]