good day.
please help , I am new in Oracle :
I use Oracle Forms 9i and want to create simple relation such as
\
physical_address -- client ,
/
with the help of REF I established relation :
Master-block : client
Detail-block : physical_address
Object REF : fk_id_client (physical_address contains fk_id_client)
With property palette established REF Item -- YES
for both data-blocks.
Enforce Primary Key -- YES
Then , apeared in the Object Navigator TRIGGERS (PRE-DELETE) , and one
of them looks like this :
------------------------------
BEGIN
DELETE FROM AT_PHYSICALADDRESS A
WHERE A.FK_ID_CLIENT = (SELECT REF(A) FROM AT_CLIENT A WHERE rowid =
:AT_CLIENT_DATA_BLOCK.rowid);
END;
------------------------------
after compiling :
Error : 336,at line 4,column 16
non-object-table "A" illegal in this context
Error : 0 , at line 2,column 4
SQL statement ignored
WHY ?!
And in general : how to create CORRECT relation ?! help .
Thanks , we****@astral.ntu-kpi.kiev.ua