Thread: PROBLEM WITH UPDATE COMMAND
Hi, i have a problem whith make a update command the record not change the sql it´s update fimacli set ficiucli = 1 , ficomcli = 57 , fidircli = 'aaa' , finomcli = 'MARIO' , sirf1cli = '0' , sirf2cli = '0' , sirf3cli = '0' , sirf4cli = '0' , sirf5cli = '0' , userid = 'MSOTO' , fifoncli = '8601812' , fifaxcli = '091811222' , fiocucli = 'INGENIERO' , fitracli = 'COMPUALL' , fiftrcli = '1234567' , fidtrcli = 'MONTSERRAT' , fiappcli = 'SOTO' , fiapmcli = 'CORDONES' , fimaicli = 'MARIOSOTOCL@YAHOO.COM' wherefiempcli = 10 andfisedcli = 1 andfirutcli = '106426481' when look the record it´s not changed any idea i have postgres 7.3.2 and redhat 8.0 thank
if you using psql update command prints no of rows updated as UPDATE X what is X in ur case? in case X is 0 where are high changes that WHERE clause did not match anything regds mallah > > Hi, i have a problem whith make a update command > the record not change > the sql it´s > > update fimacli set > ficiucli = 1 , > ficomcli = 57 , > fidircli = 'aaa' , > finomcli = 'MARIO' , > sirf1cli = '0' , > sirf2cli = '0' , > sirf3cli = '0' , > sirf4cli = '0' , > sirf5cli = '0' , > userid = 'MSOTO' , > fifoncli = '8601812' , > fifaxcli = '091811222' , > fiocucli = 'INGENIERO' , > fitracli = 'COMPUALL' , > fiftrcli = '1234567' , > fidtrcli = 'MONTSERRAT' , > fiappcli = 'SOTO' , > fiapmcli = 'CORDONES' , > fimaicli = 'MARIOSOTOCL@YAHOO.COM' > where > fiempcli = 10 and > fisedcli = 1 and > firutcli = '106426481' > > when look the record it´s not changed > > any idea > > i have postgres 7.3.2 and redhat 8.0 > > thank > > > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' > the postmaster ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/