pcsoft.us.windevCopyright 2026, PC SOFT6 Sep 2017 18:47:00 Z5 Sep 2017 01:01:00 ZHi, I use SQL Server for my backend database with windev and it appears that WD 22 no longer allows certain SQL syntax that worked in previous versions. 1. using CONVERT in a SELECT statement now gives a syntax error. example: CONVERT(int,Booking_passenger.Room_Number) AS Room_Number_Int, In the above example the IDE gives an "unexepected word" error on the second ")". 2. Using DATEPART no longer works in a WHERE clause. example: DATEPART(year, Booking_History.Departure_Date) = {pYearNUmber} in the above example "year" gives the error "year item unknown in file". I've contacted technical support but I wonder if anyone else has run into this? Thanks steve30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62578/read.awp6 Sep 2017 18:47:00 ZUpdate... you can use these, but must select from within report description. Additionally, these queries now need to be run u…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62578/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62578/read.awpSQL Syntax not supported in WD 22Philippe SBpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62557/read.awp6 Sep 2017 05:28:02 ZHi, Do you use hQueryWithoutCorrection when you are executing you queries ? The doc says: [code:text] CONVERT is used to…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62557/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62557/read.awpSQL Syntax not supported in WD 22guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62545/read.awp5 Sep 2017 21:08:00 ZIt appears that while the queries give warnings they will execute. However, queries saved as SQL are no longer available to b…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62545/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62545/read.awpSQL Syntax not supported in WD 22guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62535/read.awp5 Sep 2017 08:22:00 ZHi Steve, As an alternative to 1 you may want to use CAST instead of CONVERT. CAST(Booking_passenger.Room_Number as int) AS …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62535/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62532-sql-syntax-not-supported-62535/read.awpSQL Syntax not supported in WD 22