Home » Developer & Programmer » Forms » tab canvas (oracle IDS ,10g ,windows XP)
tab canvas [message #386208] Fri, 13 February 2009 02:29 Go to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 12422
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 12422
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
cookiemonster
Messages: 12422
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is the first block a 'control' block? Have you inadvertently declared the block to be a 'database' block?

David
Previous Topic: Condition based execute_query
Next Topic: change the title of form 10g at runtime
Goto Forum:
  


Current Time: Thu Dec 08 12:52:00 CST 2016

Total time taken to generate the page: 0.09733 seconds