Inconsistent types (7481) when validating my SQL

[cbyrne123]

Hello when i try and validate my SQL in Cognos report studio i get the below error.

ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Inconsistent types (7481)

When i use the prompt for invoice_doc.kdate i get the above error.

When i use invoice_doc.kperiod its fine however i want to prompt between dates.

I have tried a few cast functions but not sure if they are correct because i am fairly new to SQL writing.

Thanks

Chris

[MFGF]

Hello when i try and validate my SQL in Cognos report studio i get the below error.

ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Inconsistent types (7481)

When i use the prompt for invoice_doc.kdate i get the above error.

When i use invoice_doc.kperiod its fine however i want to prompt between dates.

I have tried a few cast functions but not sure if they are correct because i am fairly new to SQL writing.

Thanks

Chris

Looks like a known defect in Progress 11:

http://knowledgebase.progress.com/articles/Article/000046804

If you can tell us more detail about your report and how you need it to work we might be able to suggest a workaround?

Cheers!

MF.