Re: Forms 3.0 - block and table out of sync?
Date: 11 Feb 1994 19:10:38 GMT
Message-ID: <clement1-110294111022_at_attilla.llnl.gov>
In article <2jgaih$o2f_at_digdug.pencom.com>, dae_at_pencom.com wrote, among
other things:
>
> I have a simple Master-Detail SQL*Forms 3.0 form. While in the Master block,
> the user can type a 'P' into a non-database field to change all of the Detail
> records from non-paid to paid. I do this from the on-validate-field trigger i
> the Master block via:
>
> update Detail set paid_field = 'P' where key = :Master.key;
> commit;
> go_block('Detail');
> clear_block;
> execute_query;
>
I don't think this is the safest way to write the code, nor the most maintainable. Why not use a simple assignment?
if :Master.user_input = 'P' then
:Detail.paid_field := 'P';
commit;
end if;
Is there some objection to this that I've failed to grasp?
David Clement || Geyr nu Garmr mjok fyr Gnipahelli. clement1_at_llnl.gov || Festr mun slitna, enn freki renna.
Received on Fri Feb 11 1994 - 20:10:38 CET