Dear All,
I'm working with dbforms-2.5.august snapshot.
I have a problem with Interceptor Handling... Now I try to explain my issue:
I have a table "person" where there are 2 attributes:
-- PERSON --
ID_PERSON that is a serial (autoincremental)
CODE that is a code that I calculate with an interceptor (based on surname and
name of a person).
Then I have another table "student"
-- STUDENT --
ID_PERSON that is a ForeignKey to PERSON.ID_PERSON
CODE that is the same code as in PERSON.
Now:
when I create a new "PERSON" in the preInsert interceptor:
1. the system generates an ID_person for the table person, and this is OK for me
2. the system generates a CODE for the table person, and this is OK for me.
Then I have to inform the interceptor to insert the same two attributes on the
dependent table "STUDENT".
I can not do this operation on the same preInsert interceptor, otherwise the
system will raise a FK-error because the insertion on the table person isn't
completed yet.
I tryed to put it in the PostInterceptor but at that point I losted all the
"state" information of the class... so have I to re-query the database to know
on which record am I working?
Is there another way to accomplish something like this?
Thank You
-----------------------
Ivan Codarin
-----------------------
----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
