1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

SQL (in Progress Database) - Date - Error 7481 - Inconsistent Types

Discussão em 'StackOverflow' iniciado por fdantas, Junho 12, 2017.

  1. fdantas

    fdantas Administrator Moderador

    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...

Compartilhe esta Página