Error retrieving data from the database

[Hsiao]

Hi,

I have used a calculated data item with prompt value to enable dynamic sorting,e.g.

if (?column to sort prompt? = 1) then (column1) else (column2)

However, after we upgraded to Impromptu 7.1 (from 7.0 MR1). I have been having trouble with any comparison using prompt value. I got the following error:

[!]Error retrieving data from the database.

DMS-E-TYPENOTSUPPORTED, The data type 'unknown type' is not supported by this gateway.[/!]

Have you experienced this error? How can I get around it?

Thank you for your help on this!

Regards,
Hsiao