OraFAQ Forum: Forms » Can view the query from Edit Plus but not from Oracle Forms 10g

Home » Developer & Programmer » Forms » Can view the query from Edit Plus but not from Oracle Forms 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can view the query from Edit Plus but not from Oracle Forms 10g [message #273202]

Tue, 09 October 2007 08:18

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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 01 23:12:37 CDT 2026