Show query values on form


To show query values just like a report dialog does there are some internal classes that need to be used.

To simplify this process, I have created a class, which will take in the form group control and the query and use that to generate fields just like a report dialog would do.

The code can be downloaded from codeplex/axug

To show an example of how this looks, here is a form, with an empty group, and a button to select the query values

image

The button “Select values” is calling queryRun.Prompt for the queryrun variable defined within the form object.

 

 

 

 

image

Once the user selects the fields (user can even leave certain ranges empty, and add more range fields) the query is passed to a class along with the forms group control (i.e. “My Query Group”)

The class will then clear existing controls within the group and then add the ranges from the query.

image

Multiple data sources can be added by the user and they all show up in the group.

A shortcoming of this is that every time the class arranges the fields in the group, it first hides any existing controls. This is because, controls cannot be removed when added. So a lot of selects can cause a large memory footprint for this form

Advertisements

One thought on “Show query values on form

Leave a Reply / Comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s