Devart Forums

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.

We couldn't reproduce the problem.
Did you create your project with SDAC 3, and then upgraded to SDAC 4?

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.