Re: Alter Table using dbaccess

Posted in 1998

Topics: Server Administration, Triggers, Constraints & Referential Integrity, Platform-Specific Issues

Katrin Goericke — Wed, 15 Apr 1998 12:23:21 +0200 — source: Informix-list mailing list archive (1991-1998)

trilogix wrote: > > I'm using Informix Online Workgroup Server version 7.1 on HP-UX. When I > try to alter a table using dbaccess, I get the error message > '586 - Cursor already open'. > This happens even if no other process is running. I've tried shutting > down the online server and even the machine and restarting, but the > error message persists. Can anyone please help me? I made the same expirience and I found out that a "alter table" doesn't work with dbaccess when a check constraint was implemented for the concerning table. Probably is it a bug of dbaccess. I decided to alter the tables only with sql syntax within dbaccess instead of using the alter table menu option and it works fine. -- Gru' Katrin __________ _/_/_/_/_/ _/_/_/_/ _/_/_/_/ Katrin Goericke katrin@taz.de _/ _/ _/ _/ die tageszeitung _/ _/_/_/_/ _/ Germany _/ _/ _/ _/ D-10969 Berlin Phone: +49-30-2516092 _/ _/ _/ _/_/_/_/ Kochstr. 18 FAX : +49-30-2510694

Related threads

Glossary

dbaccess