Problem with manual update

[bilalch]

Hi dear frends

i've written the sql update command on a button press trigger as

begin
update TNA
set shipdate = :shipdate , description = :description
where TNAID = :TNAID;

commit ;
end;

but when i do this it shows PK Uniqueness error. i.e. the form tries to resave it as a new record instead of updating the record.


plz help.

 

[sem]

Are you here again ? Forms needs NO CODE for editing table once you've created a block based on it. Writing it is really bad habit, because Forms makes assumptions about existing pending changes according to your actions with Forms items, not to DML statements called from triggers.

Regards, Dima

http://seminihin.narod.ru

 

[bilalch]

sorry dear frend DIMA

i couldn't stick to ur advice due to the problem that i ws wondering if not to write this DML, then how to update some data i'm looking at in my forms.

Hearty thanks for ur precious advices.
bye

 

[sem]

You may just edit your block items, Forms builds and executes all necessary DML for you.

Regards, Dima

http://seminihin.narod.ru

 

[BJCooperIT]

bilalch,
Please read the FAQ:

What are the basic concepts of Oracle Forms? faq259-3484

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000