PRIMARY KEYS

--------------C3ED959570458D1523900899 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, We just wanted to upgrade a local Paradox 7.0 DB to an Informix 7.22 (online) DB Version. But during this conversion the system lost the primary keys. Now, the ISQL-Software recognizes the indexes and the primary keys, but the SQL-Explorer and the Borland DBEngine tell us there would be no primary keys or any regular index. I've tried different SQL-Statements (ALTER TABLE, ALTER INDEX,...) to set up new primary keys or unique indexes, but the SQL-Explorer and the DBEngine both ingnore them, while the indexes are known to the sysindexes table of informix, the SQL-Explorer tells me every time I try to refresh, the table wouldn't have the correct index. Sincerely Torsten Kleine B'ning Delphi 3.0 pro DBEngine 4.0 Informix Online 7.22 Windows 95/NT --------------C3ED959570458D1523900899 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> Hello, <P>We just wanted to upgrade a local Paradox 7.0 DB to an <BR>Informix 7.22 (online) DB Version. <P>But during this conversion the system lost the primary keys. <BR>Now, the ISQL-Software recognizes the indexes and the primary keys, <BR>but the SQL-Explorer and the Borland DBEngine tell us there would be <BR>no primary keys or any regular index. <P>I've tried different SQL-Statements (ALTER TABLE, ALTER INDEX,...) <BR>to set up new primary keys or unique indexes, but the SQL-Explorer and <BR>the DBEngine both ingnore them, while the indexes are known to <BR>the sysindexes table of informix, the SQL-Explorer tells me every time <BR>I try to refresh, the table wouldn't have the correct index. <P>Sincerely <BR>&nbsp;&nbsp;&nbsp; Torsten Kleine B&uuml;ning <H4> </H4> Delphi 3.0 pro <BR>DBEngine 4.0 <BR>Informix Online 7.22 <BR>Windows 95/NT</HTML> --------------C3ED959570458D1523900899--