GetDataSetbyQuery - Displaying results on form

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

GetDataSetbyQuery - Displaying results on form

Postby rochard » Wed Oct 27, 2004 4:34 pm

So I have a method which works to get a specific dataset and displays those records in an html table.

Now is there a way to run that same query and have the found records display in a list view on a form?

TIA
Michael Rochard
rochard
 
Posts: 142
Joined: Thu Jan 29, 2004 12:11 am

Postby pbakker » Wed Oct 27, 2004 4:50 pm

Since you have to add the columns shown on a form yourself in Developer, you can only show those columns.

With an SQL query you can retrieve the PK's for the records you want to show and then load those onto your form.

Paul
pbakker
 
Posts: 2822
Joined: Wed Oct 01, 2003 8:12 pm
Location: Amsterdam, the Netherlands

Loading SQL Query results into a form

Postby rochard » Wed Oct 27, 2004 7:04 pm

pbakker wrote:Since you have to add the columns shown on a form yourself in Developer, you can only show those columns.

With an SQL query you can retrieve the PK's for the records you want to show and then load those onto your form.

Paul


That sounds perfect but would you have an example of how to do this? TIA
Michael Rochard
rochard
 
Posts: 142
Joined: Thu Jan 29, 2004 12:11 am

Postby pbakker » Wed Oct 27, 2004 7:16 pm

pbakker
 
Posts: 2822
Joined: Wed Oct 01, 2003 8:12 pm
Location: Amsterdam, the Netherlands


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 38 guests