Kbase P110010: SELECT COUNT(*) using MS SQL DataServer returns double result set.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL DataServer
OpenEdge 10.0x
Progress 9.1E
SYMPTOM(s):
Using Progress 4GL to execute SELECT COUNT(*) from table.
Connected to MS SQL Server database via MS SQL DataServer.
Two result sets returned instead of one.
CAUSE:
This is a known issue being investigated by Development
FIX:
Workaround:
Use a "FOR EACH" statement with a counter to determine the number of records in the table.