RE: Update Statement

Posted in 2001

Martin, Wayne E. — Thu, 15 Feb 2001 14:08:38 -0500 — source: Informix-list mailing list archive (1991-1998)

Is this something like what you are trying to do: update table@database set column_name = 'somevalue' where table@database:column_name = column_name; UPDATE sunc@admin SET deal_key = "NVD" WHERE eire@dblog1:chas = CHAS_KEY; Wayne E Martin Informix Database Administrator Kmart Corporation -----Original Message----- From: Kirk Davis [mailto:kirk.davis@volvo.com] Sent: Thursday, February 15, 2001 11:39 AM To: informix-list@iiug.org Subject: Update Statement Hi All, Hope someone out there can help me with this one, it's driving me mad! Does anyone have any idea, why the statement below would not work, I just get the error " 522: Table (dblog1.eire) not selected in query." I've tried also making the first line UPDATE admin.subc, dblog1.eire but but still no luck, I've read through the Informix SQL guide, but It doesn't give me an clues?? UPDATE admin.subc SET admin.subc.deal_key = "NVD" WHERE dblog1.eire.chas = admin.subc.CHAS_KEY; Any help greatly appreciated! Best Regards to all, Kirk