OraFAQ Forum: Forms » How to build a form depending on a Query

Home » Developer & Programmer » Forms » How to build a form depending on a Query (6i)

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

How to build a form depending on a Query [message #662024]

Thu, 13 April 2017 01:26

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Hello guys,
I have a query that I use in a report

select employee_number, salary , notes from employee_table_1
union All
select employee_number, salary , notes from employee_table_2

I would like to build a form depending on this query.
any idea ? I don't intend to delete or modify any data in this form
I am using Form Builder 6i

[Updated on: Thu, 13 April 2017 02:56]

Report message to a moderator

Re: How to build a form depending on a Query [message #662028 is a reply to message #662024]

Thu, 13 April 2017 08:07

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

How about creating a view on that query and then a block based on the view?

Report message to a moderator

Re: How to build a form depending on a Query [message #662037 is a reply to message #662028]

Fri, 14 April 2017 01:07

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

Senior Member
Account Moderator

I've just done that, for testing purposes. Works well.

Create a new form
Manually create data block (as the Wizard won't offer "FROM clause query").
Choose "Query data source type"
Write your query into "Query data source name"
All columns you used in a query should be specified in "Query data source columns"
Create a canvas
Use Layout wizard to help you create layout
That's it; run the form

A suggestion: Forms offers great online Help system - use it! The simplest way in this case is to open data block's property palette window, click to "Query data source type" and press F1 which will invoke help. Read it, follow links it suggests, educate yourself.

Good luck!

Report message to a moderator

Re: How to build a form depending on a Query [message #663981 is a reply to message #662037]

Fri, 30 June 2017 10:08

amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia

Senior Member

Thank You. it Worked

Report message to a moderator

Previous Topic:	how to synchronize master and detail records
Next Topic:	How the Trigger Post-Change

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:59:48 CST 2024