Re: Compiling 4GL code in RDS 6.00 is not like RDS 4.00
Posted in 1998
I seem to remember a bug with the 6.00 version of 4GL that would give
this error on a declare statement after an into temp statement. I just
rearrianged my code to fix the problem until I got an upgrade. I believe
this problem is fixed in 6.02.
HTH
Joseph
-------------------------------------------------------------------------
Joseph Cullipher <joseph@cannonexpress.com> Standard Disclaimers Apply
-------------------------------------------------------------------------
On Thu, 5 Feb 1998, Anatoly Yu. Nelyubin wrote:
> 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
>