[DUG] firebird query parameters behaving oddly

[Richard Vowles]

Robert martin wrote:
> Hi
>
> If you never use dates as strings in your queries (i.e. always use 
> asDate or AsDateTime) you should never get locale issues.  Its one of 
> the biggest reasons to always use ParamByName instead of building SQL 
> strings IMO.

That and SQL injection attacks.

-- 
Richard Vowles, Product Evangelist
Developers Inc Ltd (for Delphi, C++ Builder, JBuilder, InterBase)
web. http://www.developers-inc.co.nz
ph. +64-9-3600231, mob. +64-275-467747, fax. +64-9-3600384, 
skype. <callto:rvowles/>, LinkedIn, http://twitter.com/RichardVowles
currently working on: Delphi2007, Rails, PHP, Air

-------------- next part --------------
A non-text attachment was scrubbed...
Name: richard.vcf
Type: text/x-vcard
Size: 271 bytes
Desc: not available
Url : http://www.adventureeducation.co.nz/pipermail/delphi/attachments/20070707/6fb382aa/richard.vcf