Simplicty and flexibility!


HowTo::

How to Use DQL Selection Criteria in QBM


Parameters


Returns/Result


Examples


Reference

How to Use DQL Selection Criteria in QBM

1. Open the document in Designer View, choose Document>>Query By Model. DataEase opens the “Query By Model” dialog;

2. Click any column or on the title of the filtered table;

3. Click the Select “This Table’s Records If” button. DataEase displays the previously entered selection criteria as a DQL expression;

4. View the criteria and then if the criteria is correct, click OK;

6. If you want to change the selection criteria, enter the new criteria directly in the box using any valid DQL expression. When you click OK, DataEase uses the new criteria to find records;

7. Click OK to close the dialog.

 

See Also


On the forum about How to Use DQL Selection Criteria in QBM

[@EOF@]...

Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien. le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

On the blog about How to Use DQL Selection Criteria in QBM


dg3_HelpView