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

Reply via email to