Devart Forums

Try to use NOW() and CURDATE in WHERE clause in Query Builder. The task list always show 1 Build Error near NOW() or CURDATE(). However, the query can be run without any error in VB.Net 2003 or MYSQL Query
What is wrong for my query in Query Builder?
Select * from Orders where datediff(NOW(), otime) <= 7

Thanks

Which version of MySQLDirect .NET do you use?
I've just checked this with v4.0 and got no error.

I believe it is 3.55.20.0 according Corelab.MySql

Thanks

Tested this with MySQLDirect .NET 3.55.23. Still no error. Try to use the latest version.