Update... WHERE not same result as SELECT
Hi,
When I execute the following SQL I get a result of 1 record found
select COUNT(*) FROM T_Porte
WHERE Territoire=10 and Rue='Ch Clément N' and Ville='St-Justin' and Porte=990 and Appartement='';
When I execute the following SQL I get a result of 0 record change
UPDATE T_Porte
SET Commerce = '0', CAMLM = '0', TerCom = Null, Fictif = '0'
WHERE Territoire=10 and Rue='Ch Clément N' and Ville='St-Justin' and Porte=990 and Appartement='';
Please remark that the WHERE clause is exactly the same.
Why I do not have the same result ?
Thank you,
Christian
P.S:. I may post screen shot but I don't know how...
Subject
Views
Written By
Posted
Update... WHERE not same result as SELECT
1344
May 06, 2017 03:14PM
1059
May 07, 2017 05:26AM
628
July 12, 2017 06:51PM
627
July 12, 2017 05:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.