Home » Developer & Programmer » Forms » 2 Problems Form Wont Run Without DataBlock / “FRM-40405”
2 Problems Form Wont Run Without DataBlock / “FRM-40405” [message #118834] Mon, 09 May 2005 03:29 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
Using Oracle8i, Form6i & Report 6i.

Requirement
1. How to run form with out DataBock
2. Avoid rising of Error “FRM-40405 No Change to Apply”

Problem Details

Developed an index / welcome form with link of all other reports & forms.
But this form won’t open unless I include (a DataBlock or dataitems in a non-DatabaseBlock).

If I include a DataBlock it give following error:-

“FRM-40405 No Change to Apply” when ever I open linked forms/reports and when ever I enter new record in link forms.

This error won’t stop/corrupt any process but rise on every above instance.

Wishes
Jawad

Report message to a moderator

Re: 2 Problems Form Wont Run Without DataBlock / “FRM-40405” [message #118838 is a reply to message #118834] Mon, 09 May 2005 03:50 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Create one block in your form. Call it CTRL for example. Make sure that it is defined as database 'false'. See how that goes.

David

How are you calling the other forms? Call_form, new_form, open_form?

[Updated on: Mon, 09 May 2005 03:52]

Report message to a moderator

Re: 2 Problems Form Wont Run Without DataBlock / “FRM-40405” [message #118840 is a reply to message #118834] Mon, 09 May 2005 04:03 Go to previous messageGo to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
Dear David

Thanks for your help but it won’t workout for me.

If I include only a Bock (with database property false or even for true) without data_items the form won’t run.

When I include text_time (with database property false or even for true) I got Error “FRM-40405 No Change to Apply” for every above action.

Using Open_Form.

Wishes
Jawad

Report message to a moderator

Re: 2 Problems Form Wont Run Without DataBlock / “FRM-40405” [message #118860 is a reply to message #118834] Mon, 09 May 2005 07:18 Go to previous messageGo to next message
subba lakshmi
Messages: 36
Registered: March 2005
Member
i think you are saying commit somewhere.give that commit in between :system.Message_Level:=5 and :system.Message_Level:=0;
i.e.,

:system.Message_Level:=5;
commit;
:system.Message_Level:=0;

check it out

from
subba lakshmi

Report message to a moderator

Re: 2 Problems Form Wont Run Without DataBlock / “FRM-40405” [message #118950 is a reply to message #118834] Mon, 09 May 2005 19:17 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What does your form do if you have no block and no items???

Put a dummy item on the block, it does NOT have to be on a canvas.

David

My bad, you have to have something displayed. But it can be a button not a data item.

[Updated on: Tue, 10 May 2005 01:11]

Report message to a moderator

Re: 2 Problems Form Wont Run Without DataBlock / “FRM-40405” [message #118965 is a reply to message #118950] Tue, 10 May 2005 01:04 Go to previous messageGo to next message
lomhanz
Messages: 18
Registered: May 2005
Location: Cebu, Philippines
Junior Member
i just couldn't imagine a form without a an item. Forms by default won't run without something navigable (of course its on a canvas). that something navigable might be an item (will hold the focus) that is in a block and on a canvas.

can you elaborate more what you really want to build? isnt it a splash screen?

Report message to a moderator

Re: 2 Problems Form Wont Run Without DataBlock / “FRM-40405” [message #118975 is a reply to message #118834] Tue, 10 May 2005 02:04 Go to previous message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
My Dears

Thanks for all who help me.
I have found my solution.
At another forum Mr. Littlefoot provide me following solution.

Make a non-database data-block.
Use following code to open forms.
------------------------------------------------
declare

I_Old_Msg_Level number;

Begin

Set_Window_Property('Index',Window_State, Minimize); /* to minimize index page*/
I_Old_Msg_Level := :System.Message_Level;
:System.Message_Level := 10;
Open_Form('path\file.fmx',activate);
:System.Message_Level := I_Old_Msg_Level;
end;

------------------------------------------------


For those you quires about “What is the need of form without data_block”

Actually it is main form just contain links for all forms.

Wishes
Jawad

Report message to a moderator

Previous Topic: datablock properties
Next Topic: row counting
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 13 22:05:39 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.