Using NLQ In VDM

Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).

Article Goal: Using the NLQ feature inside VDM

In this article we are going to cover the steps to use NLQ to create Views in VDM.

Video Tutorial:

Not yet available.

Steps To Use NLQ.

Note: NLQ uses Command Tables for the current connection. It is recommended to set up aliases on your command table using short & to the point field names with mixed casing for the best results.

1. Open VDM

2. Click on the NLQ tab.

3. Check/Enable the Command Table you want to create a query for.

4. Start entering a command that will get what you want from the table.

Example: "I need everything for orders shipped after October 1st 1997 sorted by employeeID"

5. Click Send NLQ once you have finished entering your command. You will then see the SQL statement returned below. It is recommended to verify the statement returned is getting what you want. If it is not you can adjust the SQL statement that was returned or modify the command above.

6. Run the View.