Path: utzoo!attcan!uunet!mcvax!cernvax!pan!jw
From: jw@pan.UUCP (Jamie Watson)
Newsgroups: comp.databases
Subject: Informix 4gl - form input default broken
Message-ID: <473@pan.UUCP>
Date: 15 Sep 88 19:04:20 GMT
Reply-To: jw@pan.UUCP (Jamie Watson)
Organization: Adasoft AG, Solothurn, Switzerland
Lines: 18


Given a database with a field declared as char(1), and a form to input
that field with the following specifications:

    include = ("Y","N"," "), default = " "

When a 4gl program does input with this form, the default value is not
accepted.  That means that attempting to terminate input produces the
message "This value is not among the valid possibilities".

Using the *identical* form with the Informix-SQL Perform form processor
everything works correctly.

In fact what is apparently happening is that the field is getting a null
value by default, instead of a space, because adding null to the include
list causes the form to accept the default value under 4gl.

jw