In Microsoft SQL Server you can declare DateTime and Date Fields.
When using SDAC you can set a Parameter like this way for a date-Field:
Code: Select all
qryExec.Params.ParamByName('StartDate').AsDate
Code: Select all
qrySelect.FieldByName('StartDate').As........
In Delphi you also have "TDate". So it would be nice to have a "AsDate" Funktion also when you are using FieldByName. Is there any way to achieve this?