Hi Mark,
> should the parameter have been substituted, in the file that is written?
Not sure. Like I said, I only use it to check my work when I'm modifying query
lines at runtime.
What about the settings in the TParams of the query's Params property, as I
mentioned in my post? Are they ok? Can you plug your date into the Value
property and get the result you need?
A typical statement for me is something like :
qryBomlist.Params[2].AsDate := dtpDateTo.Date;
This is after setting ftDate and ptInput, as I mentioned.
HTH,
Craig.
>PS. Is what I am trying to do common, or is it more normal to build up the >SQL
by adding lines in the code?
You should be able to do it either way.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"