Create view from 4GL cause an error
Posted in 1995
Hi , folks
I'm trying to compile 4gl file ( compiled version )
and getting syntax error.
I have : c4gl -V : INFORMIX-4GL Version 4.11.UC2
slqturbo -v : INFORMIX-OnLine Version 5.02.UC8
After preprocessing of x.4gl , a x.ec file contains strange stuff.
The sentense b.peg_count_16/c.peg_count_3*100 is transferred by pre compiler
into
b.peg_count_16 / b . peg_count_16 . peg_count_3 * 100
Is it known bug in 4.11 version that create view with join cause such kind
of errors ?
May be I lose something in syntax ?
P.s. 1. This statement works fine from dbaccess.
2. create view without join works fine from 4gl.
The SQL statement in 4GL file:
CREATE VIEW uplink_rf_loss (derived_val, record_date ) AS
SELECT b.peg_count_16/c.peg_count_3*100, b.record_date
FROM ca_4b_hr b, ca_4c_hr c
WHERE ....
The SQL statement in EC file after parser:
$ create view uplink_rf_loss ( derived_val , record_date ) as
select b.peg_count_16 / b . peg_count_16 . peg_count_3 * 100 ,
b.record_date where ....
Thanks in advance
--
-----------------------------------------------------------------
Valery Azbel
E-mail : valery@milcse.cig.mot.com
Phone : (972)-3-6969560 at home ; (972)-3-5658496 at work ;
-----------------------------------------------------------------