Local variable as record from table row [CORE2621]

[firebird-automations]

Submitted by: eXandr (i.reg)

Is related to CORE740
Replaces CORE2686
Is duplicated by CORE1998
Relate to CORE3070

Votes: 9

Syntaxis:

DECLARE VARIABLE <varname> RECORD AS [TABLE|VIEW|CURSOR|PROCEDURE[OUTPUT PARAMETERS]] <table_name|view_name|cursor_name|proc_name>;

Example:
..
AS
DECLARE VARIABLE r RECORD AS TABLE mytable;
BEGIN
...
SELECT * FROM mytable INTO :r;
SELECT fld1 FROM mytable INTO :r.fld1;
...
END;

[firebird-automations]

Commented by: Ain Valtin (ain)

Looks like a nice feature :)
Suggestion - also support to restrict the record variable to have only listed fields, ie

DECLARE VARIABLE <varname> RECORD[(field1, field2, ...)] AS ...

In that case the compiler should replace "*" in SELECT statement

SELECT * FROM mytable INTO :r;

with the field list from var declaration.

[firebird-automations]

Modified by: @dyemanov

Link: This issue is related to CORE740 [ CORE740 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue replaces CORE2686 [ CORE2686 ]

[firebird-automations]

Modified by: @asfernandes

Link: This issue is duplicated by CORE1998 [ CORE1998 ]

[firebird-automations]

Modified by: @asfernandes

Link: This issue relate to CORE3070 [ CORE3070 ]