| FRM - 40102 [message #221882] |
Wed, 28 February 2007 15:15  |
amereddy
Messages: 11
Registered: May 2006
|
Junior Member |
|
|
Hi! I have a question on how to get around FRM-40102 error.
I have master detail block. Insert/Update/Delete properties on the master block is set to "NO". It is only query block.
In the detail block, I could create/update/delete records. I should populate some default values once the user tries to create a new record in the detail block.
Once I query the data, the cursor is on one of the fields on the master block. at this point create record icon on the toolbar is disabled. If I click on the detail block, the create record icon is enabled.
Since the block is already in the insert mode, I get the error frm-401012 when I try to crate new record.
My requirement is that, when I am in the master block and hit the create record button, I should be able to go to the detail block and create a record. Since I can't use navigational triggers in when-create-record, I am kind of lost.
Any suggestions is greatly appreciated.
Regards
|
|
|
|
| Re: FRM - 40102 [message #221954 is a reply to message #221882] |
Thu, 01 March 2007 05:00  |
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
|
Senior Member |
|
|
Hi,
I don't quite understand where the problem is encountered?
You have a master block that is query only. You query a record into this block.
You navigate to the detail block, and a create record icon is enabled?
You enter your data and then click on the create record icon and get the frm-40102 error?
Is that right?
|
|
|
|
| Re: FRM - 40102 [message #222034 is a reply to message #221954] |
Thu, 01 March 2007 08:59 |
amereddy
Messages: 11
Registered: May 2006
|
Junior Member |
|
|
Thanks for the response.
That is correct. If the cursor is in the master block, The create record icon is disabled. Once I put the cursor in the detailed block, the create record icon is enabled.
The requirement is such that, I need to pre-populate some data in the detail block, when the user hits the create record icon.
Regards
|
|
|
|
|
|
| Re: FRM - 40102 [message #222068 is a reply to message #222065] |
Thu, 01 March 2007 10:39 |
amereddy
Messages: 11
Registered: May 2006
|
Junior Member |
|
|
Thanks again.
The detail block is a base table block. If my cusrsor is in detail block and I enter some data and save, It save fine.
If there are no records retrieved in the detail block, the user could choose to go to the detial block and click on the create record icon, at this point I want to default some values into the detail block.
Once my query is executed, the cursor is in the master block, at this point, my create icon is disabled. I am trying to figure out a way where this Icon is not disabled, when clicked on it, it will take me to the detail block with some pre-populated values. Since we can't have navigational triggers when-create-record, I am stuck.
Regards
|
|
|
|
| Re: FRM - 40102 [message #222493 is a reply to message #221882] |
Mon, 05 March 2007 03:14 |
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
|
Senior Member |
|
|
Hi,
I think I might have an idea. Have you tried doing a clear_block(no_validate) prior to populating the detail block values?
So you go
-> query master block - no details found
-> press create record icon
-> clear the block with no validate
pre-populate the values
allow user to complete details and save
Apologies if I still haven't quite got your requirements.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
