Nuevos registros se presentan al inicio...

[[duilioisola]]

Código SQL [-]
/* AUTOGENERADORES FIREBIRD */

set term ^;

CREATE GENERATOR GEN_MY_TABLE_ID
^

CREATE TABLE MY_TABLE (
    ID  INTEGER NOT NULL
)
^

CREATE OR ALTER TRIGGER MY_TABLE_BI0 FOR MY_TABLE
ACTIVE BEFORE INSERT POSITION 0
as
begin
    if (new.id is null) then
        new.id = gen_id(gen_my_table_id, 1);
end
^
commit work^