Re: Help in 4GL

S SATHISH-SI wrote: > > Hi, > I have a small problem in 4GL 6.01. > 1. > I have a program array of type record,whose elements i preload with values > and then call set_count(#) and use it in an Input Array Without Defaults > .This i do to,so that the user sees some values in the screen and enters > some.In my form specification file,i have specified attributes as "not > null" and "required".Despite this when the Input Array is active ,it > allows nulls and to return thro' fields.Why? I think that 'not null' still allows null values if the user never enters that field, and 'required' makes sure that the user enters a value, but he can erase it later and that still fulfills the 'required'. Anyway, the end result is that it does allow nulls, so you have to put some validation logic after input or after row, then return the user to the 'required' row and field that is null, which requires a programming hack (which should have been something on Tim's feature request list, i.e. row positioning in an input array) of making a dummy noentry field on the end of the row, and using 'next field' for this dummy field to position to the next row down to get down to the row you want. Good Luck, Douglas Wilson > > 2. > In Online 7.1,i establish referential integrity on a column in a table, > the referenced column is SERIAL,the referencing column allows NULLS .Why? > > Bye > > ****************************************************************************** > S.Sathish > email :ssathish@cmcbang.ernet.in > ******************************************************************************