Interbase IBX to Firedac TDatetime

[Orrengg 0]

H,

 

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....

 

Thanks!

 

[Orrengg 0]

wow...nothing... No one ran into this?

[Hans J. Ellingsgaard 21]

I have converted from IBX to FireDAC without any problems with the datetime fields. What database are you using?

[Orrengg 0]

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...