| Subject | Re[2]: [firebird-support] Update statement seems to stall |
|---|---|
| Author | Pavel Menshchikov |
| Post date | 2005-09-28T19:35:43Z |
Hello Aage,
AJ> Bob Murdoch wrote:
AJ> end_date = (end_date + 1) - 0
AJ> ?
He mentioned that the DB SQL dialect was 1. It behaves differently in
such calculations as compared to dialect 3.
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com/
AJ> Bob Murdoch wrote:
>> ...AJ> Isn't this equivalent to
>> I am running the following query:
>>
>> update
>> sku_price
>> set
>> end_date = (end_date + 1) - (1/24/60/60)
>> ...
AJ> end_date = (end_date + 1) - 0
AJ> ?
He mentioned that the DB SQL dialect was 1. It behaves differently in
such calculations as compared to dialect 3.
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com/