Kbase P56118: SQL query works against one table, returns no data when run
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/12/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
ASP.Net code is working fine when a query is run against one table
The same query, when run against another table returns no data
Progress 9.1D06
CAUSE:
The SQL WIDTH field in the metaschema was too small for one of the fields being returned in the query
FIX:
Increase the SQL WIDTH field in the metaschema for the problem field so that it is large enough to hold the maximum amount of data possible for that field