What is it with CR9?
All I'm trying to do is report on some records where my DATE_ADDED field is between two dates.
So I add a RecordSelectionFormula:
{DATE_ADDED} in date(2008,7,12) to date(2008,7,13)
but my OLE DB provider, Sibpro2.dll, gives me an error with the CONVERT function unknown.
I guess CR9 is generating a SQL statement that includes the unknown CONVERT function - probably valid if I'm using SQL Server (argh! Microsoft strikes again with non standard SQL extensions!) but I'm using Firebird.
Blah.
And I have to get this finished this afternoon.
No comments:
Post a Comment