Number field and Prompt not compatible

[navshiv]

Hi

I have a field in a report which is changed from string to number so that it can be totalled. I want to compare this totalled field with a value that is entered into a prompt so that only certain information is showed (total field > prompt field)

The prompt has been set to number (have tried all sorts of data types like integer, double etc) and the field is a double type.

Every time I apply the summary filter (as its a calculated field I am comparing) and click ok to enter in a value I get a error message.

The error is:

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request.
[Lotus][ODBC Lotus Notes]Incompatible data types in expression

I'm guessing the fact that it is a lotus notes database does not help the matter one bit!!!!

I can't understand how I am able to select the prompt in the summary filter if the 2 data types are not compatible.

Any ideas?

Thanks in advance

 

[griffindm]

Navshiv,

It is apparent from the error message that the comparison is being passed to the Notes database, and that it is the Notes database, not Impromptu, that is generating the error. That said, two approaches to eliminate the problem would be to write the results to a hotfile and then query the hotfile to make the comparison (Notes no longer involved by this step), or to write the comparison using local functions to prevent the comparison from being passed to Notes. If-then-else logic is usually sufficient for this, or try a function that only shows the i symbol rather than the database 'disk' symbol. You may also be able to change the client-server setting to flexible process (if it is not there already) to have more processing happen locally.

Dave Griffin

 

[navshiv]

I have changed the report to Flexible processing and seems to have done the trick!

Thanks for that Dave