Icon View Incident Report

Serious Serious
Reported By: Alec Mironov
Reported On: 11/22/2007
For: Version 1.06 Build 1
# 2487 External Functions Not Working Correctly in SELECT WHERE Clause With Insensitive Result Sets

I have created an external function in dll. That function returns Boolean (actualy it does not really matter). Function works just fine when I use it in SELECT statement. As the second parameter I use a field from the selected table. It suppost to be a value from a row. Which is good. When I am trying to use the same function in WHERE clause it doesn't work. Debugging shows me that the second parameter is the same all the time (actually a column from the first row in the table).

SELECT MyFunction('SomeValue', MyTable.CLOBField1) as test FROM MyTable



Resolution Resolution
Fixed Problem on 11/23/2007 in version 1.07 build 1


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image