| tab canvas [message #386208] |
Fri, 13 February 2009 02:29  |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
In tab canvas i have two tabs.Each tab has a single form.
when i retrieve the data, every time it asks
'Do u want to save the changes you have made' dialog box.My question is when i retrive the date that message box doesnot come send solution
thanks and regards
varosh
|
|
|
|
| Re: tab canvas [message #386238 is a reply to message #386208] |
Fri, 13 February 2009 04:24  |
cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
That doesn't make much sense
| Quote: | Each tab has a single form
|
Tabs belong to forms, not the other way round.
Did mean each tab has a single data block?
| Quote: |
when i retrive the date that message box doesnot come
|
Date? did you mean data?
Does that mean you don't want the message to appear or that it doesn't appear?
That message only appears if you change a database item value so that oracle thinks there are changes that need to be saved. If you don't want it to appear - don't change any items.
|
|
|
|
| Re: tab canvas [message #386246 is a reply to message #386238] |
Fri, 13 February 2009 04:53 |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
Ya sir its data not date..
As i said earlier i have two tabs containing two forms based on 2 different tables without any relationship between them..
Now my issue is, in the first tab i mean the first form i would click enter query and after entering value, i have to execute query icon..
after i click the execute query, immediately iam getting that window DO U WANT TO SAVE CHANGES?, which i dont want appear..
Pls help to overcome this !
Thanks and Regards
varosh
|
|
|
|
| Re: tab canvas [message #386248 is a reply to message #386208] |
Fri, 13 February 2009 05:05 |
cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
| Quote: |
As i said earlier i have two tabs containing two forms based on 2 different tables without any relationship between them..
|
No you don't
| Quote: |
Tabs belong to forms, not the other way round.
|
You have two tabs presumably containing two DATA BLOCKS.
two questions:
1) When you click on enter-query does the form actually go into enter-query mode?
2) Do you have any code in any KEY-EXEQRY or PRE-QUERY triggers?
|
|
|
|
| Re: tab canvas [message #386250 is a reply to message #386248] |
Fri, 13 February 2009 05:26 |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
Hi!
Yes it goes to enter query mode when i click enterquery icon..
And i didnt write any coding in the triggers you specified..
Thanks and Regards
varosh
|
|
|
|
| Re: tab canvas [message #386278 is a reply to message #386208] |
Fri, 13 February 2009 06:59 |
cookiemonster
Messages: 13972
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Well you've got some code somewhere that's changing the record status.
You're going to have to debug this the hard way I suspect.
Put message(:system.form_status);
commands in various triggers and work out at which point it changes from NEW to CHANGED. Then work out what bit of code is causing that to happen.
|
|
|
|
| Re: tab canvas [message #386512 is a reply to message #386278] |
Sun, 15 February 2009 23:15 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Is the first block a 'control' block? Have you inadvertently declared the block to be a 'database' block?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
