Jump to content

Interbase IBX to Firedac TDatetime

Recommended Posts



We have many legacy applications using IBX components to connect to our Interbase databases. We are slowly moving to Firedac for our connectivity and are finding that Firedac supports milliseconds in TDatetime calls sent to Interbase while the IBX components do not. This is causing issues in our applications - specifically Record changed by another user when using TClientDatasets to do updates. 


We have already added mapping rules to get the datatypes to work properly. Is there a way to configure firedac to drop the milliseconds on the datetime fields so we can maintain backwards compatibility? I do not want to change every single place we use a datetime and truncate the milliseconds...that would be a ton of work....




Share this post

Link to post

Interbase. The issue is that Firedac writes datetime fields with milliseconds. IBX does not. So, when my old apps try and modify a record, it thinks the record has changed because when it searches for the record to change it cannot find it because the datetime does not match (off by the milliseconds)...


When we change ALL legacy apps to Firedac the problem would disappear - but who knows when that may be. So I am looking for a way to make firedac not send the milliseconds...

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now