Re: Integrity constraint and INPUT ARRAY

Vadim Park (pivot@taxpol.krasnoyarsk.su) wrote: : Hi, : I've got a table with following schema : create table tbl : ( f1 smallint no null, : f2 smallint no null, : f3 smallint no null) : The problem is when i modify it with INPUT ARRAY and accidently insert new : line : i can't leave the one, 'cause 4GL says "This field requires an entered : value". : The same occurs when there are no rows retrivied from the table, I've done : nothing and try to exit the INPUT ARRAY. In last case I at least can press : interrupt key to escape as far as there is nothing to save. : I would not like to change schema because of integrity constraint. : Is there workaround how i can leave empty input array line for my case? The only way I found is not to define inp_rec record like tab.* It isn't pretty, because if I want to check integrity of data, I have to write checking code in 4GL. This is duplication of integrity constraint, but I don't know any other workaround. : Thanks in advance, : --------------------------------------------------------------- : Vadim G. Park | Email: pivot@taxpol.krasnoyarsk.su : Tax Police | Fax : (3912) 27-07-69 : Krasnoyarsk, Russia | Voice: (3912) 27-02-83 : --------------------------------------------------------------- -- Zdeno Miklas e-mail: ash@softec.sk SOFTEC spol. s r. o. phone : 42-7-273805 ext.128 Kutuzovova 23 fax : 42-7-272537 831 03 Bratislava SLOVAKIA