pcsoft.us.windevCopyright 2026, PC SOFT21 Apr 2015 15:58:00 Z21 Apr 2015 00:33:00 ZI am using WinDev 19 and if I use MOD() in an SQL WHERE clause WinDev returns error; "Error returned by <> server: Internal Error in WDSQL DLL." Basically I need to know if the pages being selected are exactly divisible by the pagecount field in the data file. I have simplified my code to do a test proof and this generates the error; dsSTMT is Data Source cConnection is Connection = DatabaseConnection nPageValue is int = 64 cFilterString is string = StringBuild("WHERE MOD(%1,pagecount)=0",nPageValue) SQLStatement is string = "Select * from laydown %1" IF HExecuteSQLQuery(dsSTMT ,cConnection ,hQueryWithoutCorrection,StringBuild(SQLStatement,cFilterString)) THEN Info("Success") ELSE Info(HErrorInfo()) END Strangely if I wanted the MOD the other way around, It does not error; MOD(pagecount,%1)=0 I have a work around by using; DIV(%1,pagecount)=ROUND(DIV(%1,pagecount),0) But that not very neat, has anyone else come across this? or is there another way to achieve the same result? I have used MOD() in another programming languages SQL WHERE so I don't thinks it's an SQL standard issue. I am relatively new to WinDev so maybe it's me, but I can't see that it is. Gary.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51699/read.awp21 Apr 2015 15:58:00 ZHi guys, Unless I'm missing a point, it is not necessary to make a sub query. You can do that in a simple query. SELECT *,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51699/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51699/read.awpMOD() returns error when used in SQL WHEN clauseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51683/read.awp21 Apr 2015 09:38:00 ZThanks Arie, I'll have a play with that, it looks neater than mine, I'll try and do some tests and see if your way is faster …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51683/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51683/read.awpMOD() returns error when used in SQL WHEN clauseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51681/read.awp21 Apr 2015 09:05:00 ZHi Gary, I did a small test and with the same error. I looks like MOD is not supported in the WHERE clause?? But you can use …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51681/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51681/read.awpMOD() returns error when used in SQL WHEN clauseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51680/read.awp21 Apr 2015 00:45:00 ZSorry I overlooked as you had it in HExecuteSQLQuery(..)https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51680/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51680/read.awpMOD() returns error when used in SQL WHEN clauseguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51679/read.awp21 Apr 2015 00:42:00 ZGary I guess you miss out one line of code as below: ... cFilterString is string = StringBuild("WHERE MOD(%1,pagecount)=0",…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51679/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51675-mod-returns-error-when-used-sql-when-clause-51679/read.awpMOD() returns error when used in SQL WHEN clause