[stackoverflow] [progress Openedge Abl] Sql (in Progress Database) - Date - Error 7481 -...

[modhorat]

Using SQL on a Progress Database (SQL92)

Using a piece of software (designed for Pervasive) that allows writing of reports etc, which can be emailed to users

I've been receiving the following error with my SQL:

SQL Debug: [DataDirect][ODBC PROGRESS Driver][PROGRESS]Inconsistent Types (7481)
​

The following code works perfectly:

Select * FROM pub."stockmaster"
Where ("sm-sold" = 0 OR ("sm-sold" = 1 AND "sm-selldate" >= '2017-06-01'))


The problem (error) comes when I use the software's built-in 'variables', such as @MONTHSTART@ which displays as '01 June 2017'

Select * FROM pub."stockmaster"
Where ("sm-sold" = 0 OR ("sm-sold" = 1 AND "sm-selldate" >= @MONTHSTART@))


I need to use this 'System Variable' so I don't have to keep changing the SQL date manually every month

The Field "sm-selldate" is formatted as type Date in Progress

These system variables work perfectly fine on a Pervasive Database

I've searched couple forums and seen suggestions of CONVERT(DATETIME, but no workable solution

Continue reading...