I am using Delphi 6 and Interbase 6 and have the following
in the script of a DataBase
create trigger CID_NOinsert for CHILD
before insert
position 0
as
begin
NEW.CID_NO = gen_id(cld_number_gen,1);
end!!
Upon scrolling onto a new record in a grid (and despite the above) no value is evident in CID_NO.
However if I enter a number (anything!) into CID_NO AND move off the record (thus Posting) the number which I have entered is corrected to what it should be according to the above trigger. And becomes visible upon scrolling back to the record.
The frustrating thing is the absolute need to have to enter a No into CID_NO manually.
Can anyone please suggest how to get around this?
Thanks in advance.
Terry