Re: Required Attribute for 4GL
Posted in 1994
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
Jessica Kung (jesskung@solomon.technet.sg) wrote: : Hello can anyone help me with this problem that I have encountered while : developing some programs using informix-4GL : In the form specification, I have included a REQUIRED attribute in one of : my field. Back in my program, I used the INPUT with a WITHOUT DEFAULTS : clause. During runtime, I did not key in any value for that particular : field, and the RDS just accept and store a null value into the database : for that field. Currently, I am forcing a check on that field to ensure : that the user key in a value. But the list of keys is too long and tideous : to do likewise. I believe that in most versions it is required that the column must be defines as NOT NULL in the database for the REQUIRED keyword to work. DCT -- @ David Tomlinson @ @ dtomlnsn@netcom.com @ @ "By day fantastic birds flew through the petrified forest, and @ @ jeweled crocodiles glittered like heraldic salamanders on the @ @ banks of the crystalline river. By night the illuminated man @ @ raced among the trees, his arms like golden cartwheels, his @ @ head like a spectral crown...." @