|
Re: how to user go_block in when-validate-item [message #449550 is a reply to message #449521] |
Tue, 30 March 2010 07:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
GO_BLOCK is a restricted procedure and can not be used in the WHEN-VALIDATE-ITEM trigger.
You could use it in, for example, KEY-NEXT-ITEM trigger, but it wouldn't fire if user navigates through items using a mouse.
Or, you could set master block navigation style property to "Change data block" and put EXECUTE_QUERY into a PRE-BLOCK trigger (of a detail block). If the item you are talking about is the last in the master block, navigating out of it will do the job.
However, why and what are you, actually, trying to do? As you didn't provide much information, I can't imagine what should be the case here.
Because, detail block should be populated upon querying master block, not during insert. Are you inserting values into an item? Is it the only item in the master block?
Do explain it a little bit more and you might hear some more ideas.
|
|
|
|
|
|
Re: how to user go_block in when-validate-item [message #450248 is a reply to message #450238] |
Mon, 05 April 2010 23:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
OK; but what does this "solution" have to do with the original "question"? You were asking how to perform query of the detail block, while your last message says that there's a description item there. Does it mean that the whole detail block is now shrank into a single item?
|
|
|