Home » Developer & Programmer » Forms » FRM - 40102
FRM - 40102 [message #221882] Wed, 28 February 2007 15:15 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #222065 is a reply to message #221882] Thu, 01 March 2007 10:29 Go to previous messageGo to next message
scorpio_biker
Messages: 154
Registered: November 2005
Location: Kent, England
Senior Member
Apologies for yet more questions Razz

I take it your detail block is a base table block? So you place focus in a field in the detail block, some data is entered, the icon is clicked and then you get the error?

Or do you get the error before, when you try to pre-populate some of the fields in the detail block?
Re: FRM - 40102 [message #222068 is a reply to message #222065] Thu, 01 March 2007 10:39 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: when button pressed
Next Topic: LOV problem
Goto Forum:
  


Current Time: Mon Dec 05 04:42:59 CST 2016

Total time taken to generate the page: 0.23906 seconds