Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement