>What will I do if I use Oracle or anything else instead of SQL Server? Do I have to create view for each different backend? The software for distribution, so it is possible that customer use different client/server database. Any suggestions?
>Thanks.
>Dmitriy

Hi Dmitriy,

Simplest solution of CURDATE() problem is,
Use view parameter instead of using any function
I mean

dtoday = DATE()

SELECT * FROM table_name;
WHERE ddate = ?dtoday


Bye