Home » Developer & Programmer » Forms » How to build a form depending on a Query (6i)
How to build a form depending on a Query [message #662024] Thu, 13 April 2017 01:26 Go to next message
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 Go to previous messageGo to next message
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?
Re: How to build a form depending on a Query [message #662037 is a reply to message #662028] Fri, 14 April 2017 01:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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!
Re: How to build a form depending on a Query [message #663981 is a reply to message #662037] Fri, 30 June 2017 10:08 Go to previous message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
Thank You. it Worked
Previous Topic: how to synchronize master and detail records
Next Topic: How the Trigger Post-Change
Goto Forum:
  


Current Time: Thu Mar 28 21:25:46 CDT 2024