Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 2 of 2 total

Fri, Jun 28 2019 7:55 AM	Permanent Link
Mirco Malagoli	Hi, this SQL "SELECT * FROM evento JOIN eventi ON evento.idevento = eventi.idx WHERE idevento < :Pevento AND stato = :Pstato AND dataora BETWEEN :PturnoI AND :PturnoI+86399999 ORDER BY idevento DESC" if executed on 4.46 server work ok, if executed on 4.48 server raise this error "DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Date, or Timestamp expression but instead found + in SELECT SQL statement at line 2, column 44" What's wrong? Thanks!
Fri, Jul 26 2019 1:54 PM	Permanent Link
Raul Team Elevate	Mirco Malagoli wrote: << Hi, this SQL "SELECT * FROM evento JOIN eventi ON evento.idevento = eventi.idx WHERE idevento < :Pevento AND stato = :Pstato AND dataora BETWEEN :PturnoI AND :PturnoI+86399999 ORDER BY idevento DESC" if executed on 4.46 server work ok, if executed on 4.48 server raise this error "DBISAM Engine Error # 11949 SQL parsing error - Expected NULL, Date, or Timestamp expression but instead found + in SELECT SQL statement at line 2, column 44" What's wrong? >> Which build of version 4.48? Recent Build 5 addressed a issue that this looks like - incident 4754 Raul