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.

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd say that Metalink had said enough.

Report message to a moderator

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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What version of Forms are you using? If the detail block is not base table, what is it?

David

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
He said that
Quote:
query data source type of detail block is "Procedure"

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 20:26:39 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.