[DUG] firebird query parameters behaving oddly

[Edward Koryagin]

Firebird likes timestamp so much...
--- Tracey <tracey at logis.co.nz> 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: delphi-bounces at delphi.org.nz
> [mailto:delphi-bounces at delphi.org.nz] 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 <tracey at logis.co.nz> 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: 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
> 
> 
> Edward Koryagin
> 
> Send instant messages to your online friends
> http://au.messenger.yahoo.com 
> _______________________________________________
> 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
> 
> 
> _______________________________________________
> 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
> 


Edward Koryagin

Send instant messages to your online friends http://au.messenger.yahoo.com