Re: Problems with primary key

Greg Silverman wrote: > > We're running Informix SE 7.24 on a Linux box and we're having a problem > with reporting of primary keys through dbaccess. Whenever we try to get > info on primary key(s) that we have created on a table all we see is > "Running..." at the bottom of the dbaccess screen (and it never gets > reported).We have tried to create the primary key both through a Create > Table statement and the menu. Interestingly though, an index is created > and the primary key can be seen through MS Access 97 when attached as a > remote table. Also, we seem to be having a problem exporting tables from > Access to > the server -- in particular, the primary keys do not get transferred > (possibly due to problems listed above...) Do the keys show up in dbschema? If so then they should be there and working and I'd report it to Informix as a dbaccess bug. Art S. Kagel