-360 Cannot modify table or view used in subquery

Posted in 2003

LUQUE Valdivia Omar — Tue, 16 Dec 2003 12:22:37 -0500 — source: Usenet: comp.databases.informix

Hello everybody, My query : UPDATE GN_PACIENTE SET GRUPO = "G00" WHERE NROHIS IN (SELECT NROHIS FROM GN_PACIENTE INNER JOIN TBPERPRIMARI ON TBPERPRIMARI.PRICDCIP || "00" = GN_PACIENTE.NROHIS WHERE pricdsituacion = 1 AND priidtippersona < 6 ) I read the Informix error messages and i saw this paragraph, but I don't Understand that : "This action is not allowed because of the danger of getting into an endless loop." Why is danger? I can do that in SQLServer and Access, why not in Informix? Thanks Omar. sending to informix-list

↪ replying to LUQUE Valdivia Omar

Obnoxio The Clown — Tue, 16 Dec 2003 20:53:12 +0000 — source: Usenet: comp.databases.informix

LUQUE Valdivia Omar wrote: > My query : > > UPDATE GN_PACIENTE > SET GRUPO = "G00" > WHERE NROHIS IN > (SELECT NROHIS FROM GN_PACIENTE INNER JOIN TBPERPRIMARI ON > TBPERPRIMARI.PRICDCIP || "00" = GN_PACIENTE.NROHIS WHERE pricdsituacion = > 1 AND priidtippersona < 6 ) > > I read the Informix error messages and i saw this paragraph, but I don't > Understand that : "This action is not allowed because of the danger of > getting into an endless loop." Why is danger? > > I can do that in SQLServer and Access, why not in Informix? What version of Informix? -- "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche