Subject | Re: [IBO] Date issue ( again ) |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-03-12T08:13:05Z |
Try
IB_Query.SQL := 'SELECT * FROM SalesCall WHERE SCDate BETWEEN :dSCFrom
AND :dSCTO'
Your original solution ought to work, but I guess IB has some problems with
there being no spaces between >= and : I think using between is more
readable, and I hope (though haven't checked) it can improve the plan IB
chooses.
HTH,
Set
IB_Query.SQL := 'SELECT * FROM SalesCall WHERE SCDate BETWEEN :dSCFrom
AND :dSCTO'
Your original solution ought to work, but I guess IB has some problems with
there being no spaces between >= and : I think using between is more
readable, and I hope (though haven't checked) it can improve the plan IB
chooses.
HTH,
Set