![]() |
#1
|
|||
|
|||
![]()
I have an Access Database with a Date/Time column. I have a fdquery that retrieves the table with the column in it. I can print it on fastreports and it works just fine. I have a maintenance program for it and it shows up in a datetimepicker just fine. last phase of my project requires that I use a clientdataset to access a specific feature. I actually got it all in place tdatasetprovider points to the dataset of the firedac query and the clientdataset points to the datasetprovider. When I try to use the component that requires a clientdataset, my date column is ignored and won't populate. we have figured out why is because the clientdataset thinks my date/time column is ftTimeStamp and not ftDateTime.
is there a way in the firedac query to force my date column to be ftDateTime? |
#2
|
|||
|
|||
![]()
You could try this:
https://forums.embarcadero.com/messa...ssageID=680492 And then the part on the Connection.FormatOptions: Code:
FConnection.FormatOptions.OwnMapRules := True; with FConnection.FormatOptions.MapRules.Add do begin SourceDataType := dtDateTimeStamp; TargetDataType := dtDateTime; end; with FConnection.FormatOptions.MapRules.Add do begin SourceDataType := dtTime; TargetDataType := dtDateTime; end; |
#3
|
|||
|
|||
![]()
In my firedac query the field type is always ftTimeStamp.
when i used the Format(mydate, 'mm/dd/yyyy') as mydate_txt in my query and created a new field mydate_txt, it will actually work on my mailmerge but as text only and i lose all of the formatting options available to the mailmerge process related to date fields. i am not sure if the maprules is not find dtDateTimeStamp as equal to the ftTimeStamp or if it is the MS Access side to always treat datetime fields as timestamp. |
#4
|
|||
|
|||
![]()
I would say it's the maprules, but that should be an easy test on your side.
I'm not a firedac user, so cannot verify anything on this part. But users with similar problems all pointed to this maprules, so give it a try |
![]() |
Thread Tools | |
Display Modes | |
|
|