Make sure that you have the "Request Sensitive Result Set" check box *un-checked*.  That should fix the problem for now.

There appears to be an issue with sensitive result sets and computed columns that include sub-selects, but only with remote sessions.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,
Testing in the Manager, unchecked as advised, same query run and getting this message:

 ****   ElevateDB Error #1001 A filter error occurred (Filter not found)   ****

The EDBServer is installed Remote at a client site.

To test, I changed to Local. However, it ran successfully just once and re-running returns the error above.

........................................................
PascalNetwork.com
pascal - the language we love

Tim,
I checked and then unchecked the Request Sensitive just now and that cause the error message to appear. Reconnected, and the error does not repeat itself.

Is this a quick fix? Or do I need to do a workaround as I require both Sensitive Result and Remote.

<< Testing in the Manager, unchecked as advised, same query run and getting this message: >>

This is a different issue, and a continuation of this issue:

https://www.elevatesoft.com/incident?action=viewaddr&category=edb&release=2.31&incident=4755

only this time it is caused by the derived table in the SELECT expression.  I have fixed this.

For now, just ignore this error - you most likely won't encounter it in your application because you won't be switching between a sensitive/insensitive result set *after* executing the query at least once.

Tim Young
Elevate Software
www.elevatesoft.com

<< Is this a quick fix? Or do I need to do a workaround as I require both Sensitive Result and Remote. >>

I won't be able to get you a quick fix for the sensitive/remote issue.  I'm still looking into it, but it has to do with the combination of computed BLOB expressions, derived tables, sensitive result sets, and remote sessions.  IOW, it's a perfect storm of circumstances.

Another workaround is to just CAST() the expression as a VARCHAR:

SELECT *,
CAST((SELECT LIST(TerritoryDescription, ' / ')
FROM Territories
WHERE RegionID = Region.RegionID) AS VARCHAR(255)) AS RegionTerritoriesDescription
FROM Region
WHERE RegionID =  1

but that will involve an upper limit on the number of items in the list.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,
Ok, thanks.

I shall do the workaround and hopefully not encounter any significant issue in the meantime.

Regards.

........................................................
PascalNetwork.com
pascal - the language we love