Path: utzoo!attcan!uunet!mcvax!cernvax!pan!jw
From: jw@pan.UUCP (Jamie Watson)
Newsgroups: comp.databases
Subject: Informix 4gl "construct" statement broken
Message-ID: <471@pan.UUCP>
Date: 13 Sep 88 21:13:24 GMT
Reply-To: jw@pan.UUCP (Jamie Watson)
Organization: Adasoft AG, Solothurn, Switzerland
Lines: 33


The Informix 4gl "construct" statement is broken in such a way as to render
it useless anywhere the "DBDATE" environment variable is used to change the
default date format.

We use "DBDATE=DMY2."; this works perfectly for output with the display,
display array and print statements, and for input with the input and
input array statements.  Input with the construct statement apparently
doesn't respect this setting, though.  The following program shows the
problem:

database fooey
main
  define
    d date,
    q, s char(512)

  open form f from "broken"
  display form f
  input d from broken
  construct by name q on broken
end main


On running this program, I can type "13.9.88" at the input statement,
and it works fine.  I then type exactly the same thing at the construct
statement, and I get "Error in field".

Apparently we have to tell our customers that they can type dates in
European format for input, but they have to use U.S. format for any
queries???

jw