Hi John,
Thanks for the code, I just added it to the Trunk. Since I don't have a MSSQL server it's up to you to test it.
One final question: Is it possible to use UTF collation instead of Latin1 as you suggested in the mssql.initial.sql file? If yes, what's the exact string for MSSQL?
Regards, Thomas
WOODS John wrote:
Whilst on the subject of different databases some of you may be interested in a port to MS SQL Server that I have made.
[...]
This is a new function that is required to place the *now() *mysql function* *or* getdate() *mssql* *function in SQL query strings. For this to work all occurrences of the string “now()” in the project have to be replaced with a call to this function.
Please let me know whether any of you can make use this port.
John Woods