General information
Category:
Forms & Form designer
>Also working on a pseudo query designer. Heres the idea in case anyone else is trying to tackle this. One form has a combo box listing all the tables. Changing its value requeries a second combo box which pulls up all the fields in the table selected and triggers a third combo box which identifies the field type and requeries to allow valid comparisons (math for numerics etc). A query is then created and stored in a table field along with the table name, field name and comparison value. The next section allows you to combine queries by number ie. (1 or 2) would be a new query for query 1 or query 2. I use the () to indicate combination queries that are record independent and [] to indicate that the query must match for each record. (ie (1 or 2) would be data in table matches query 1 or query 2 and [1 or 2] means the record in the table matches query 1 or query 2. It's some complex coding but the result is an easy to use, very flexible query by example report generator for any
>group of tables, that stores common queries for reuse with minimal effort.
>
>Projects to keep you awake to 3 am.
The query designer, which you have mentioned, I am doing the same thing, and One thing I wanted to ask you ?? Have you seen the query designer provided by foxpro, which is gaving a grid/list box which is having combo box and a record mover, the same one which we see in the table designer where either we can select the field types from a combo box and at the left hand side is a scroller/mover is given through which we can change the position of field. Any ideas about that ???
what I am doing is creating unique values from the selected field in the values combo box, which gives the user the facility to either type or select it from the list. I don't know whether you are doing the same or not.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only