Delphi 7
sDAC 4.00.0.6 Trial
I have a tmsQuery component on a datamodule.
The query is :
Select distinct p.uid
from Payment p, Invoice I, paydetail d
where
p.Distributed = false and
p.UID = d.PaymentUID and
(d.InvoiceUID = I.UID) and
(i.Closed = true) and
(i.InvoiceDate >= :BeginDate) and
(i.InvoiceDate <= :EndDate)
When I open the parameter editor, I get :
edItem Data Type not found.
I ignore those and set the datatypes for the parameters to DateTime, set parameter type to in, check 'null value', click OK, but it isn't saving the settings.
edItem DataType not found
I am converting from DBISAM
I tracked it down to DBISAM allows ftDate as a parameter type.
I had to go into the dfm and changed it from ftdate to ftDateTime.
I had to go into the dfm and changed it from ftdate to ftDateTime.