How to add a query for a single table?

Article summary

Did you find this summary helpful?

Thank you for your feedback

Answer:

To create a query for a table run the process

From the run procedure line : gui\system\d-qyrtyp.w
Once open, check to be sure the query you are thinking of adding isn't already there.
If not, click the add button.
In the Table section add the table - for instance checkrecon In the selection area add:

FOR EACH checkrecon fields(checkrecon) NO-LOCK where true the syntax is For each tablename fields(tablename) no-lock where true
There should be NO spaces between the s in "fields" and the left parenthesis.
Capitalization is unimportant.
Spacing is critical.

Was this article helpful?