[DUG] firebird query parameters behaving oddly

[Tracey]

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