Kbase P110723: SQL-92: How to convert returned data to VBScript supported data types?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/11/2005 |
|
Status: Unverified
GOAL:
SQL-92: How to return decimal data types that are usable by VBScript?
GOAL:
ODBC: How to retrieve decimal data types that are usable by VBScript?
GOAL:
ASP: How to convert SQL-92 decimal data types to VBScript supported data types?
FIX:
In SQL-92, all fields of type decimal are returned in vbDecimal format that is not supported in Microsoft VBScript. A solution is to use the Visual Basic Scripting Edition CDbl() function to convert the returned value to a Variant of subtype Double that is supported in VBScript.
Similarly, when aggregate expressions on decimal or integer fields are returned by an SQL-92 query, conversion is needed because the Progress returned variant decimal data type is not supported in Microsoft VBScript. In this case, the Visual Basic Scripting Edition CLng() function may be used to convert the result to a Variant of subtype Long that is supported in VBScript.