Re: Required Attribute for 4GL

David Tomlinson (dtomlnsn@netcom.com) wrote: : 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 Unlike sql, the 4gl needs an entry in syscolval for the table.field in question. Run upscol. Choose validate, select the table and the field, select validate. Recompile your form using form4gl. You don't need a not null field for this to work -- gburnore@netcom.com