OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Form on SQL query, modify query after form is created

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Form on SQL query, modify query after form is created (oracle 11g, windows 7)

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

Form on SQL query, modify query after form is created [message #595289]

Mon, 09 September 2013 23:34

SeniorInvissible
Messages: 34
Registered: July 2013

Member

I know how to create a form based upon a SQL query but have no idea how to navigate back to the SQL query once the form is created. Could anyone help?

Report message to a moderator

Re: Form on SQL query, modify query after form is created [message #595299 is a reply to message #595289]

Tue, 10 September 2013 00:21

Littlefoot
Messages: 21795
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

That's a good question (and I don't have an answer).

I have never used that form type; tried to create one right now and I'm as puzzled as you are. I have no idea what would be its purpose ... there are no processes, no relation between form items and underlying tables' columns, nothing. Therefore I tried to find what to do with such a form. Documentation says almost nothing ("Creates a form based on the columns returned by a SQL query such as an EQUIJOIN"). I've found questions similar to yours, but there was no answer whatsoever. Unfortunately, I can't assist.

What would you do with such a form, anyway? Or did you just want to see how it looks like?

Report message to a moderator

Re: Form on SQL query, modify query after form is created [message #595300 is a reply to message #595299]

Tue, 10 September 2013 00:30

SeniorInvissible
Messages: 34
Registered: July 2013

Member

I was trying to create a report with some data and when a tuple is selected it is displayed in another form as a sub-exercise for one of my classes before I start the master-detail form. Thanks anyway.

Report message to a moderator

Previous Topic:	ORA-01403: no data found, error unable to fetch row
Next Topic:	Linking two reports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 02 09:39:31 CST 2023