Hmmm actually I think It has something to do with mysterious locale issues on my new laptop.. I had all sorts of date issues with mssql and Reporting services too.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edward Koryagin Sent: Friday, 6 July 2007 3:54 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] firebird query parameters behaving oddly time part of timestamp datatype in Firebird? --- Tracey <[EMAIL PROTECTED]> wrote: > 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 Edward Koryagin Send instant messages to your online friends http://au.messenger.yahoo.com _______________________________________________ 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
