Or use parameters

sql->ParamByName("ThatDate")->AsDateTime = date_type_variable;

Tom

Dne 3.7.2011 6:53, allies_xposs@... napsal(a):

> Usually, convert date to string at delphi use : formatdatetime('mm/dd/yyyy',thisdate.date).
>
>
> Thanks
> Allies xposs
> Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!
>
> -----Original Message-----
> From: Ricardo Uzcategui<ricardouven@...>
> Sender: firebird-support@yahoogroups.com
> Date: Sat, 2 Jul 2011 20:32:42
> To:<firebird-support@yahoogroups.com>
> Reply-To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Date format problem Windows 7
>
> Try the date in english format..
>
> MM/DD/YYYY in string when put ThisDate and ThatDate params in delphi.
>
>
>
> On Sat, Jul 2, 2011 at 2:10 PM, Opcode Software<oppenhiemerb@...>wrote:
>
>> **
>>
>>
>> Hi Thomas -
>>
>> thanks for the reply. No, makes no difference if I remove the "invoice"
>> clause.
>> Actually - its in Delphi 2009 that I first noticed the problem and used
>> IBExpert to check the sql was returning data (was previously compiled in
>> Delphi
>> 2005 so suspected the development tool was to blame.)
>>
>> I think I have found a solution in Delphi (which is my main concern) so not
>> gong
>> to delve deeper at this point.
>>
>> Thanks again for your feedback :)
>>
>> Dave.
>>
>>
>> ----- Original Message ----
>> From: Thomas Clarke<thomas.p.clarke@...>
>> To: firebird-support@yahoogroups.com
>> Sent: Sat, 2 July, 2011 16:46:40
>> Subject: Re: [firebird-support] Date format problem Windows 7
>>
>> On Sat, Jul 2, 2011 at 9:11 AM, oppenhiemerb<oppenhiemerb@...>
>> wrote:
>>
>>> **
>>>
>>>
>>> Hi -
>>>
>>> I recently moved to WIndows 7 from windows XP and am experiencing some
>> odd
>>> behaviour with regards the database I am using.
>>>
>>> Specifically, the interpretation of the date on the 2 versions of windows
>>> seems to be causing problems.
>>>
>>> I am using Firebird 2:0 and IBExpert (latest versions.)
>>>
>>> ON the XP machine on the same database - this query works (returns data.)
>>>
>>> SELECT TRANSID,TRANSDATE,INTERNAL_REF,DELIVERYITEM,ARCHIVED from INVOICE
>>> WHERE INVOICETYPE = 'INVOICE' AND (TRANSDATE BETWEEN :ThisDate and
>>> :ThatDate) ORDER BY TRANSID DESCENDING;
>>>
>>> ON the WIndows 7 machine (using the same database and same software) the
>>> same statement does not return any rows.
>>>
>>> I have checked the Display format and regional-specific settings in the
>>> Windows control panel and it all seems correct a.
>>>
>>> Any help would be much appreciated.
>>>
>>> Thanks.
>>>
>>> Dave.
>>>
>>>
>>>
>>
>> Dave,
>>
>> I run similar queries on Win7 machines all of the time with Firebird 2.5.0
>> and it works fine regardless of the windows data format or of the IBExpert
>> date format. Are you sure there is not something else going on. I would
>> remove the condition
>>
>> INVOICETYPE = 'INVOICE'
>>
>> and see what happens.
>>
>> Regards.
>>
>> Thomas Clarke
>> Cyber Sea Incorporated
>> #6 Kingston Terrace
>> Flint Hall
>> St. Michael
>> Barbados BB11070
>>
>> voice: (246) 234-9692
>> email: tclarke@...
>> web: http://cybersea.biz
>>
>> [Non-text portions of this message have been removed]
>>
>> ------------------------------------
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> Visit http://www.firebirdsql.org and click the Resources item
>> on the main (top) menu. Try Knowledgebase and FAQ links !
>>
>> Also search the knowledgebases at http://www.ibphoenix.com
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>> Yahoo! Groups Links
>>
>>
>>
>
>
>