Re: D4gl - Columns with not null
On 2 Dec 1998, Steven Weiss wrote:
> We're running D4gl 2.02 on NT 4 workstation. We've compiled the programs
> and forms on SCO Openserver 5.04 and seem to be having the following
> problem when running the programs.
>
> The form has the following type definition
>
> f001=tableName.columnName;
>
> tableName.columnName is defined on the database as being a NOT NULL column.
> The input by name statement lets nulls through however.
>
> Does anyone know if this is a known bug and if there is a solution for it.
> We are also using fglschema 2.01.1a, Possibly this is where the problem
> lies.
I was unable to reproduce the problem with my simple test case, shown
below. Can you send a minimal version of your test case which does
reproduce the problem. I was testing with a pre-release version 2.10.4C1
on Solaris 2.6 using the D4GL p-code compiler. However, I don't think that
there's been a bug fix for this issue so the environment should not matter.
Yours,
Jonathan Leffler (jleffler@informix.com) #include <witticism.h>
Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN
Informix IDN for D4GL & Linux -- http://www.informix.com/idn
--tnul.sql--
create database tnul;
create table tnul(c01 serial not null, c02 cha r(30) not null);
--tnul.per--
database tnul
screen
{
c01[f000]
c02[f001 ]
}
end
tables tnul
end
attributes
f000 = tnul.c01;
f001 = tnul.c02;
end
--tnul.4gl--
database tnul
main
define r record like tnul.*
open form f from "tnul"
display form f
while true
input by name r.*
insert into tnul values(r.*)
end while
end main