Home » Developer & Programmer » Forms » Can view the query from Edit Plus but not from Oracle Forms 10g
Can view the query from Edit Plus but not from Oracle Forms 10g [message #273202] Tue, 09 October 2007 08:18 Go to next message
ashamg2k
Messages: 18
Registered: October 2007
Junior Member
Hi All,

There is Record Group of type static hence there is no query shown in the .fmb file when opened from Oracle Forms.
But when i open this .fmb file from Edit Plus i can view the query inside it.
Can anyone please why is this? how do i view the query from the Oracle Forms

Thanks in advance
Asha
Re: Can view the query from Edit Plus but not from Oracle Forms 10g [message #273320 is a reply to message #273202] Tue, 09 October 2007 23:45 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What made you think that Oracle Forms does not store your static record group in a 'select' statement?

David

Typo: 'stroe' instead of 'store'.

[Updated on: Thu, 11 October 2007 01:13]

Report message to a moderator

Re: Can view the query from Edit Plus but not from Oracle Forms 10g [message #273353 is a reply to message #273320] Wed, 10 October 2007 02:10 Go to previous messageGo to next message
ashamg2k
Messages: 18
Registered: October 2007
Junior Member
Hi David,

I know this is really strange! but its true.
From the Oracle Forms i cannot view query(Static record group)
but if i open the same form in Edit plus i can view the query.
I even tried to create a .txt file even there its not present.

Asha
Re: Can view the query from Edit Plus but not from Oracle Forms 10g [message #273595 is a reply to message #273353] Thu, 11 October 2007 01:16 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I don't consider it to be strange that Oracle decided to store a static record group as a 'select' statement. It means that a static and dynamic record group would be handled in a similar fashion at run time.

Have a look at FormsTool. A link to it is in the FAQ.

David
Previous Topic: name of current window
Next Topic: How to get the functionality of Active X in Oracle 10g
Goto Forum:
  


Current Time: Wed Dec 07 06:41:37 CST 2016

Total time taken to generate the page: 0.09293 seconds