Define it as a date and pass it a date using AsDateTime.
"Mark Derricutt" <[EMAIL PROTECTED]> on 05/02/99 08:37:11
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: [DUG]: SQL (again)
I tell ya, this thing is REALLY starting to P**S me off....
If I hard code the string:
where
S.Vessel = C.Object AND
S.Separator = "SP1" AND
C.MeasDate = "04/01/1998"
every runs ok... (well, the datas crap cause its using wrong data).
but if I use:
where
S.Vessel = C.Object AND
S.Separator = :Separator AND
C.MeasDate = :MeasDate
with the code:
dm.Query.ParamByName('MeasDate').AsString :=
FormatDateTime('mm/dd/yyyy',StartDate);
the query doesn't open. The parameter is defined as being a string in the
params editor...
Is there anything simple I'm missing here???
BEGIN:VCARD
VERSION:2.1
N:Derricutt;Mark
FN:Mark Derricutt
ORG:PB Power (NZ) Ltd;Geothermal Division
TITLE:Software Developer
TEL;WORK;VOICE:649-377-9941
TEL;HOME;VOICE:649-846-3763
TEL;CELL;VOICE:6421-216-5062
TEL;WORK;FAX:649-377-9946
TEL;HOME;FAX:649-377-9946
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;Auckland;Level 2=0D=0A60 Cook
Street;Auckland;;;New Zealand
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Auckland=0D=0ALevel 2=0D=0A60 Cook
Street=0D=0AAuckland=0D=0ANew Zealand
ADR;HOME;ENCODING=QUOTED-PRINTABLE:;;46 Tranmere
Road=0D=0ASandringham=0D=0A;Auckland;;;New Zealand
LABEL;HOME;ENCODING=QUOTED-PRINTABLE:46 Tranmere
Road=0D=0ASandringham=0D=0A=0D=0AAuckland=0D=0ANew Zealand
URL:http://www.wibble.net/~naked
URL:http://www.pbpower.net
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:19990204T203710Z
END:VCARD
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
