Home » Developer & Programmer » Forms » FRM-30409: Delete Record Behavior for the relation is invalid. (form6i, Linux)
FRM-30409: Delete Record Behavior for the relation is invalid. [message #297509] Fri, 01 February 2008 03:25 Go to next message
msuphaluk
Messages: 20
Registered: December 2007
Location: BKK,Thailand
Junior Member

Dear,
I am facing an error "FRM-30409: Delete Record Behavior for the relation is invalid.".
My form has 2 blocks, master and detail block. The query data source type of master block is "FROM clause query" and query data source type of detail block is "Procedure". I got this error when I created a relatinship of them. I checked in Metalink, it said that this case is a limitation of Master-Detail. The detail block must be base table only.
Does anyone have experience like my case and how to address this issue?

Regards,

Suphaluk M
BKK, Thailand.
Re: FRM-30409: Delete Record Behavior for the relation is invalid. [message #297529 is a reply to message #297509] Fri, 01 February 2008 04:18 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say that Metalink had said enough.
Re: FRM-30409: Delete Record Behavior for the relation is invalid. [message #297569 is a reply to message #297509] Fri, 01 February 2008 07:02 Go to previous messageGo to next message
msuphaluk
Messages: 20
Registered: December 2007
Location: BKK,Thailand
Junior Member

Thank you for your information.

Suphaluk M.
Re: FRM-30409: Delete Record Behavior for the relation is invalid. [message #297820 is a reply to message #297509] Sun, 03 February 2008 22:49 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What version of Forms are you using? If the detail block is not base table, what is it?

David
Re: FRM-30409: Delete Record Behavior for the relation is invalid. [message #297831 is a reply to message #297820] Sun, 03 February 2008 23:05 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
He said that
Quote:
query data source type of detail block is "Procedure"
Re: FRM-30409: Delete Record Behavior for the relation is invalid. [message #297841 is a reply to message #297831] Sun, 03 February 2008 23:22 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Yea, he did too. Okay, then he's stuck with redesigning how things will be done. For example, use a non-database 'master' and a more involved 'detail' which is handled by the stand-alone procedure.

David
Previous Topic: how to manage many list items in forms 6i?
Next Topic: how to set iconic path in the variable UI60_ICON through registry?
Goto Forum:
  


Current Time: Thu Dec 08 14:02:56 CST 2016

Total time taken to generate the page: 0.07550 seconds