Re: Set up variable prior to CONSTRUCT

Posted in 1998

Octav Chiriac — Fri, 18 Sep 1998 10:30:55 +0300 (EETDST) — source: Informix-list mailing list archive (1991-1998)

H wrote: >Hi, > >I want to implement a CONSTRUCT statement that includes a field that >was preset with a value before entering the CONSTRUCT but this field >is cleared, or set to null, on entering the CONSTRUCT statement. > >My code is: > >DISPLAY "JK" TO stsze.sizeid >CONSTRUCT g_q01_txt > ON stsze.sizeid, stsze.descr, stsze.lastuser >FROM stsze.sizeid, stsze.descr, stsze.lastuser > >I want the sizeid field to be set to a value so that the user has the >choice of leaving it there or overriding it. > >We are running Informix RDS V 4.0 but will be moving to V 4.2 soon. I don't remember about v4.2, but in versions 6.x you could use CONSTRUCT g_q01_txt ON stsze.sizeid, stsze.descr, stsze.lastuser FROM stsze.sizeid, stsze.descr, stsze.lastuser BEFORE CONSTRUCT DISPLAY "JK" TO stsze.sizeid ... I think you can use this in 4.2 too, but i'm not very shure. Best Regards, Octav -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 20 96 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com