Hello !
I think about upgrade from 4GL RDS 4.x to 4GL 6.00 (and about new
server).
Now i have many application, which was compiled in 4GL correctly, but
i can not compile them in the RDS 6.0
For example, i can not compile this code:
DROP TABLE temp_1
LET wherePart = shift1(wherePart)
SELECT z.code,z.zname,m.maska,l.tarif,u.name,g.gname,
s.servname, l.date_end
FROM zone_fn z,OUTER mask_fn m,OUTER(tar_fn l,unit u,grp_conn g,service
s)
WHERE z.code=m.code_zone
AND z.code=l.code_zone
AND u.code=l.code_unit
AND g.code=l.code_grp
AND s.code=l.code_serv
INTO TEMP temp_1
LET stText =
'SELECT * FROM temp_1 WHERE ',wherePart CLIPPED, ' ORDER BY ',
wherePart1 CLIPPED
PREPARE stId1 FROM stText
DECLARE c1 CURSOR FOR stId1
|
| CURSOR not on SELECT statement.
| See error number -363.
But when i comment this SQL operator
SELECT z.code,z.zname,m.maska,l.tarif,u.name,g.gname,
s.servname, l.date_end
FROM zone_fn z,OUTER mask_fn m,OUTER(tar_fn l,unit u,grp_conn g,service
s)
WHERE z.code=m.code_zone
AND z.code=l.code_zone
AND u.code=l.code_unit
AND g.code=l.code_grp
AND s.code=l.code_serv
INTO TEMP temp_1
all work correctly
Thank's for any response