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 , webber (AT) astral (DOT) ntu-kpi.kiev.ua

Not working with Forms for last few years, but here are some general
good rules:

- put referential integrity into the database, not an application
- instead of using SQL for DML in the application, create stored
procedures in the database and call them from client. Then you can
put your business logic into them. They can be reused by other
applcations as well.

Jan



Vysochin Artem <webber (AT) astral (DOT) ntu-kpi.kiev.ua> wrote