Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
Another Error # 11949 from 4.46 to 4.48 |
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 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |