Nexus- date issue

rbuser

I've converted numerous reports from FlashFiler to Nexus-based reports.

All is well with the exception of front end queries that rely on dates. I get the following;

"NexusDB: ,unnamed TdaChildNxQuery instance>: Query execution failed:
Unexpected exception ojbect raised: [Exception] Type mismatch (nxtDateTime <> nxtDate when comparing
customer.settledate, Date '2009-06-14') [no error code]."

It doesn't actually matter that the report was converted. Any new reports in which I refer to a date gives me a type
mismatch error.

Thanks for any advice anyone can provide.

John

nicocizik

Hi John,

Which version of ReportBuilder and Delphi are you using? Are you able to
recreate this behavior using the Nexus demo located in the \Demos\4. EndUser
Databases\NexusDB\... directory?

Other customers that have had this issue have found that when converting
from one DB to another, simply changing the DatabaseType does not change the
type saved down for each dataview in the .rtm file. A manual replace-all is
usually needed. dtFlashFiler -> dtNexusDB

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com