 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Alexander Muylaert
Guest
|
 Posted: Wed Apr 28, 2004 12:34 pm Post subject: Urgent please: MS-SQL UPDATE WHERE Doesn't work |
 |
|
Hi
I have a prepared ado query. It contains the following simple statement
UPDATE [CUSTOMERS]
SET
[Country] = :Country_1,
[Zip] = :Zip_1
WHERE
([ID] = :ID) AND
([Country] <> :Country_2 OR [Zip] <> :Zip_2)
This doesn't seem to work. The updated rowcount is always 0.
According to one of my fellow developers, this has something to do with the
value of the fields beïng fetched/replaced early.
Anybody has an idea?
Kind regards
Alexander
|
|
| Back to top |
|
 |
Alexander Muylaert
Guest
|
| Posted: Wed Apr 28, 2004 12:48 pm Post subject: Re: Urgent please: MS-SQL UPDATE WHERE Doesn't work |
|
|
okay
I figuered it out
ZIP contained the value NULL.
Kind regards
Alexander
"Alexander Muylaert" <ask (AT) hotmail (DOT) com> wrote
| Quote: | Hi
I have a prepared ado query. It contains the following simple statement
UPDATE [CUSTOMERS]
SET
[Country] = :Country_1,
[Zip] = :Zip_1
WHERE
([ID] = :ID) AND
([Country] <> :Country_2 OR [Zip] <> :Zip_2)
This doesn't seem to work. The updated rowcount is always 0.
According to one of my fellow developers, this has something to do with
the
value of the fields beïng fetched/replaced early.
Anybody has an idea?
Kind regards
Alexander
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
