Porting 6.03 reports to 10.X+

rbuser

I've ported 6.03 reports, (Flashfiler) over to 10.07 (Nexus).

Datetime fields in Flashfiler converted to Datetime fields in Nexus. All seems to be working with the
exception of dates.

I get: NexusDB: Query execution failed:
DateTime mismatch (nxtDateTime <> nxtDate) when comparing (Customer.settledate, DATE "2010-01-01".

Any ideas as to where I should be looking to correct this?

Thanks,

John

nardmoseley

I don't quite follow the question. However, I recommend downloading a trial
version of RB 12 and perform the same test.

If you still have an issue then please provide more details.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Nard,

Thanks for the help.

I can't yet port this application beyond the current RB version.

Given that the fields should both be DateTime fields, and all other functions within the program recognize the fields as
such, I naturally think it is an RB issue.

Have any issues ever cropped up with Nexus Date/DateTime fields before?

Thanks again.

John

nardmoseley

I don't know enough about the details of the issue you are encountering to
know the cause. If you have an issue with RB 10, then I can only recommend
testing with RB 12.

If you would like to create a simple example that we can build and run, we
can check it out using RB 12 and the Delphi debugger. Please create a
simple, minimal example, use standard Delphi components and RB. Send in zip
format to support@



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com