LocalAdapter AsDateTime DBISAM

Data Abstract
1

Hi, I have run into an issue using TDAMemDataTable in a service using a TDALocalDataAdapter on the ServerDataModule. It works fine except for when I am trying to update a timestamp field in a DBISAM table. The applyupdates is resulting in a DBISAM error expecting a timestamp, but instead ‘4/1/2014 9:01:01 AM’. So it seems like the DBISAM driver is not handling the correct sql formatting of the datetime. Updating this way works fine from the client using the remotedataadapter.

tblTest.FieldByName(‘AddDate’).AsDateTime := Now;

‘4/1/2014 9:01:01 AM’ is what the sql is attempting to post, but it should be ‘2014-4-1 9:01:01 AM’.

Any ideas?

Thanks

2

I created a simple test case and it seems to work ok. I am going to try and figure out what the difference is.

Thanks

3

Hello,
We also couldn’t reproduce it on a simple testcase.