Re: Problems with primary key

Art S. Kagel wrote: > > 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 I have a vague recollection of seeing something similar in version 7.10 (approx) of DB Access. The details elude me now. It looked very much like a bug to me at the time. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/