Problems with primary key
Posted in 1998
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...)
Any ideas what's going on here?
--
Greg Silverman <gms@tc.umn.edu>
University of Minnesota Cancer Center