The date string is probably not being escaped correctly. Perhaps try
ParamByName(‘from’).AsDate = FromDat; ParamByName(‘to).AsDate = ToDat; Tracey wrote:
Hi allI 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 recordsI 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 ------------------------------------------------------------------------ No virus found in this incoming message.Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.10.0/887 - Release Date: 5/07/2007 1:55 p.m.
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ 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
