Kbase P82345: Getting 'SQL_NO_DATA_FOUND' when using an SQL-92 query with unnamed parameter.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/07/2004 |
|
Status: Unverified
FACT(s) (Environment):
Windows
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Getting 'SQL_NO_DATA_FOUND' when using an SQL-92 query with unnamed parameter.
Connecting to a Progress database using ODBC.
Developing a report using the MS Visual Studio .NET Reporting Services. The report is based on a dynamic query that prompts the user to input the value of an unnamed parameter similar to:
SELECT *
FROM pub.customer
where pub.customer.name > ?
CAUSE:
The resulting query; after the user input; has an empty result set. That is no records satisfy its conditions.
FIX:
The message 'SQL_NO_DATA_FOUND' appearing in the ODBC TRACE file 'SQL.LOG' is expected in these circumstances. It simply informs the user that there were no records matching the conditions of the query after the parameter value was input.
For example, if the user input 'zzzzzzzz', the SQL.LOG file would include the above message indicating that there are no customers whose name is > 'zzzzzzzz'.