| compilation error [message #415761] |
Wed, 29 July 2009 03:26  |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
hi
i m making a form in which i m having two blocks based on the same table
in first block i m having empno,earningdeduction,item1,item2 fields
and i had set the database property to no for all these items
now in my second block i m also having some items and i had created a master detail relation using the query
prmamed.empno=prmamed1.empno and prmamed.earningdeduction=prmamed1.earningdeduction
now when i m running this form then i m getting this compilation error:-
FRM-30407: Block must have at least one database item.
Block: PRMAMED
FRM-30113: Block must have non-query-only database item.
Block: PRMAMED
Created form file MODULE1.fmx
but my fmx is coming and it's working properly the way i need my form to run but i have to remove this compilation error could someone of u please help me out .
|
|
|
|
|
|
| Re: compilation error [message #415767 is a reply to message #415766] |
Wed, 29 July 2009 04:19  |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
Hello Mr.Littlefoot
thanks for the reply sir but if i m setting the database data block property to no then i m getting this compilation error:
FRM-30416: Relation's master block is a control block.
Relation: PRMAMED_PRMAMED1
Block: PRMAMED
Form: MODULE1
FRM-30085: Unable to adjust form for output.
|
|
|
|
|
|
| Re: compilation error [message #415773 is a reply to message #415769] |
Wed, 29 July 2009 04:36 |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
Hello Mr.cookiemonster
sir if i m deleting the relationship then i m getting the same compilation error and also the database error as:
FRM-40508 ORACLE ERROR:unable to insert record
|
|
|
|
|
|
|
|
|
|
| Re: compilation error [message #415783 is a reply to message #415761] |
Wed, 29 July 2009 05:05 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
There is no point trying to run a form untill you've fixed the compilation errors. I assume you're actually running one created previously.
What's the Database Data Block property of the PRMAMED block currently set to?
And next time copy and paste the error messages - screen shots are really hard to read.
|
|
|
|
| Re: compilation error [message #415784 is a reply to message #415783] |
Wed, 29 July 2009 05:15 |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
|
Database Data Block property of the PRMAMED block currently set to yes right now and sir i had just made this form i m not running the previous one
|
|
|
|
| Re: compilation error [message #415786 is a reply to message #415766] |
Wed, 29 July 2009 05:22 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
| Littlefoot wrote on Wed, 29 July 2009 10:10 | Block 'prmamed' has been created as a database data block (check its property palette). In that case, at least one item must be a database item. Otherwise, as you've chosen to make it a control block, set its "database data block" property to "No".
|
|
|
|
|
| Re: compilation error [message #415790 is a reply to message #415786] |
Wed, 29 July 2009 05:50 |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
sir but if i m setting the database data block property to no then i m getting this compilation error:
FRM-30416: Relation's master block is a control block.
Relation: PRMAMED_PRMAMED1
Block: PRMAMED
Form: MODULE1
FRM-30085: Unable to adjust form for output.
and if i m deleting the relation also and setting the database data block property as no then i don't get the compilation error but again the FRM-40508:ORACLE ERROR and when i press f1+shift then i got the database error
sql statement in error:
INSERT INTO PRMAMED(EMPNO,EARNINGDEDUCTION,PAYPERIOD,REFNO,REFDATE,AMT,PAYCALPERIOD) VALUES (:1,:2,:3,:4,:5,:6,:7)
error:
ORA-01400: cannot insert NULL into ("PRIME"."PRMAMED"."EMPNO")
|
|
|
|
|
|
| Re: compilation error [message #415793 is a reply to message #415791] |
Wed, 29 July 2009 05:59 |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
actually i making this form to save data to the database and this should be done employee and earningdeduction wise so i m taking both of these items in my first block and to populate these item's i had made lov's now based on these two item's i have to fill all other detail of the employee so i m taking all other item's in the second block and at a tme the end user can enter 10 records for the same employee so i m having 10 records in my second block .
so how can i remove one of the block sir
|
|
|
|
| Re: compilation error [message #415796 is a reply to message #415791] |
Wed, 29 July 2009 06:07 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
| Littlefoot wrote on Wed, 29 July 2009 11:51 | It seems that all those problems would be gone, only if you remove one of the blocks. You've said that both of them are based on the same table (if so, how come that one of them contains only non-database items?) - why did you do that? What's wrong with one block? What problem are you trying to solve?
|
this one: save trigger not working
@smicky - since this is directly related to the other thread it would have simpler if you'd just continued that one.
Try setting Copy Value From Item property of the detail blocks empno item to be PRMAMED.empno.
The relationship was doing that for you but since you've had to remove it you're going to have to do it manually.
|
|
|
|
|
|
| Re: compilation error [message #415798 is a reply to message #415791] |
Wed, 29 July 2009 06:10 |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
sir,
could you suggest me to build this form in different way is there any other way i could solve my problem i m getting mad i don't know what to do please help me out..
|
|
|
|
| Re: compilation error [message #415799 is a reply to message #415796] |
Wed, 29 July 2009 06:12 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
| cookiemonster wrote on Wed, 29 July 2009 12:07 |
Try setting Copy Value From Item property of the detail blocks empno item to be PRMAMED.empno.
The relationship was doing that for you but since you've had to remove it you're going to have to do it manually.
|
|
|
|
|
| Re: compilation error [message #415976 is a reply to message #415799] |
Thu, 30 July 2009 00:42 |
simcky
Messages: 38
Registered: July 2009
|
Member |
|
|
hello Mr.CookieMonster
As u said "Try setting Copy Value From Item property of the detail blocks empno item to be PRMAMED.empno"
This trick is working for me my form is now running without any compilation and without any database error
Thanks a lot sir 
[Updated on: Thu, 30 July 2009 00:43] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
