Have you tried passing them as dates instead of strings? eg
ParamByName('from').AsDate = FromDat; (previously checked valid date)
Brian
----- Original Message -----
From: Tracey
To: 'NZ Borland Developers Group - Delphi List'
Sent: Friday, July 06, 2007 1:38 PM
Subject: [DUG] firebird query parameters behaving oddly
Hi all
I have in my code many areas where queries are "strung" together then
executed. These queries are parameterized. However I am having problems with
my date parameters.
If I have my sql string looking like this:
SQL.Add('Select stuff');
SQL.Add('From tables ');
SQL.Add('Join more tables on keys');
SQL.Add('Where DataDate >= :from');
SQL.Add('And DataDate <= :to');
ParamByName('from').AsString = sFromDat; (previously checked valid date
loaded into string)
ParamByName('to).AsString = sToDat; (previously checked valid date loaded
into string)
These queries work, however I seem to be missing records.
If I do the unthinkable and string the date values in with the query:
SQL.Add('Select stuff');
SQL.Add('From tables ');
SQL.Add('Join more tables on keys');
SQL.Add('Where DataDate >= ''' + sFromDat + '''');
SQL.Add('And DataDate <= ''' + sToDat + '''');
I get the correct amount of records
I wouldn't even know where to start on this one, I am leaving the params as
they are in the working code, but not happy about it.
Any revelations?
Tracey
------------------------------------------------------------------------------
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
