OraFAQ Forum: Forms » dynamic sql in forms

Home » Developer & Programmer » Forms » dynamic sql in forms

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

dynamic sql in forms [message #117571]

Thu, 28 April 2005 05:35

oralover
Messages: 97
Registered: January 2005

Member

hi all!

i m using Dev6i and 10g, i want to give an user-interface (form) to retrieve data from any of given tables. for example i used list-box to choose table from and another a list-box to choose table columns from and 2 or 3 criterias for where clause and when user press button this will query the database and show the data in forms interface. how i can do it??? if possible please give an example.

thanks for help.

Report message to a moderator

Re: dynamic sql in forms [message #117943 is a reply to message #117571]

Mon, 02 May 2005 01:00

oralover
Messages: 97
Registered: January 2005

Member

knock knock knock....
any help please????

Report message to a moderator

Re: dynamic sql in forms [message #117982 is a reply to message #117943]

Mon, 02 May 2005 07:03

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Hold your horses! A little patience never hurt anyone...

Now, as for your question: The problem would be layout.

I'll get back to you later on.

MHE

Report message to a moderator

Re: dynamic sql in forms [message #118075 is a reply to message #117571]

Mon, 02 May 2005 23:27

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Populate the first LOV from USER_TABLES.

Populate the second LOV from the fields of the table of the first LOV.

Add your criteria and build the dynamic SQL that you need.

Your block will EITHER have to be ALL characters fields OR you will have to display or hide, and move on the canvas the fields of the data type that you need (DATE, NUMBER, CHARACTER, etc).

You will have to populate your control table row at a time and field at a time.

David

PS. Last one of the 'display/hide and move fields' forms I saw built took about 60 person days. Use characters fields only and don't worry about the data length in the initial version.

Report message to a moderator

Re: dynamic sql in forms [message #118160 is a reply to message #118075]

Tue, 03 May 2005 07:02

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I agree. It's not that simple. I'd say, limit the number of columns allowed to, say, 15.

Have you taken a look at the Oracle Spreadtable OCX? Perhaps that's of any use. Never used it myself though...

MHE

Report message to a moderator