[DUG] firebird query parameters behaving oddly

[Brian Wrigley]

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: delphi at delphi.org.nz
  Admin: http://delphi.org.nz/mailman/listinfo/delphi
  Unsubscribe: send an email to delphi-request at delphi.org.nz with Subject: unsubscribe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.adventureeducation.co.nz/pipermail/delphi/attachments/20070706/e1f42d8f/attachment-0001.html