Kbase P141577: PROWIN32 crashes when executing code with a static query and MOD function against a DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/18/2009 |
|
Status: Unverified
SYMPTOM(s):
PROWIN32 crashes when executing code with a static query and MOD function against a DataServer
Crash occurs when compiling and/or running a piece of code against a DataServer
Stack trace from PROWIN32 reads:
odbc_whrnt
odbc_whrnt
odbc_whrnt
odbc_whrnt
FACT(s) (Environment):
Code contains static query
Static query has a WHERE clause with 2 sections, 1 of which utilizes the MOD function, for example:
OPEN QUERY q FOR EACH customer NO-LOCK, EACH order WHERE customer.custnum = order.custnum AND order.WarehouseNum = (customer.CreditLimit MOD 100) NO-LOCK.
PROWIN32 does not crash when executing an equivalent dynamic query
PROWIN32 crashes when executing code against DataServer for MS SQL Server
PROWIN32 crashes when executing code against DataServer for Oracle
PROWIN32 does not crash when executing same code against a Progress database
Progress 9.1E
OpenEdge 10.x
Windows
MS SQL Server
Oracle
CAUSE:
Bug# OE00180241
FIX:
Option #1
Use a dynamic query in place of the static query
Option #2 (may not be viable)
Remove the MOD function in the WHERE clause