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"

Reply via email to