Firebird likes timestamp so much... --- Tracey <[EMAIL PROTECTED]> wrote:
> 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 > 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
