Re: Compiling 4GL code in RDS 6.00 is not like RDS 4.00

In article <34D96720.4DBC@permonline.ru>, Anatoly Yu. Nelyubin <anatol@permonline.ru> writes >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 > try listing the columns of the table here. I suspect the compiler cannot expand * as the table does not exist at compile time.. > 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 -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care