Microsoft KB Archive/45979: Difference between revisions
m (Text replacement - "<" to "<") |
m (Text replacement - ">" to ">") |
||
Line 15: | Line 15: | ||
If the field name is not in one of the databases listed in the From clause, then Q+E displays the following error message | If the field name is not in one of the databases listed in the From clause, then Q+E displays the following error message | ||
<pre> Query field not found <fieldname | <pre> Query field not found <fieldname> | ||
</pre> | </pre> | ||
where <fieldname | where <fieldname> is the actual field name not found. | ||
When using the Order By clause, the field name does not have to be one of the names in the select clause. | When using the Order By clause, the field name does not have to be one of the names in the select clause. | ||
|} | |} |
Latest revision as of 10:19, 21 July 2020
SQL Order By Clause Must Be a Field Name in Q+ELast reviewed: October 31, 1994 |
SUMMARYWhen using the Order By clause with a SQL select statement, the parameter must be a field name in one of the databases listed in the From clause. If the field name is not in one of the databases listed in the From clause, then Q+E displays the following error message Query field not found <fieldname> where <fieldname> is the actual field name not found. When using the Order By clause, the field name does not have to be one of the names in the select clause. |
KBCategory: kbother Last reviewed: October 31, 1994 |