AUGUST 9, 2022:\n\nWORKAROUND FOR GROUP_CONCAT() USING OPENROAD\n\nCode:\n\ndeclare\ni = integer not null;\nx = integer not null;\nvConcat = varchar(500) not null;\nvText = varchar(100) not null;\nenddeclare\n\n{\n///////workaround\ni = 1;\n\nSELECT DISTINCT (al_ccode) as tbl[i].txt_code\nfrom airline\n\n\tbegin\n\n\t\ti = i + 1;\n\n\tend;\n\nfor x = 1 to tbl.lastrow() do\n\t\n\tselect concat(al_name, ' (',al_icaocode,')') as vText\n\tfrom airline\n\twhere al_ccode = :tbl[x].txt_code\n\t\n\tbegin\n\t\n\t\tvConcat = vConcat + ' ' + vText + ' | ';\n\t\t\n\tend;\n\t\n\ttbl[x].txt_con = vConcat;\n\tvconcat = '';\n\t\nendfor;\n\n}