Board index » delphi » informix primary key

informix primary key

Delphi 4+5 don't appear to recognize informix 7.31 primary keys...
sqlexplorer under d5 sees them but
sqlexplorer under d4 doesn't... i think the problem is that the primary key
names(assigned by informix) have a space as the first character of the index
name... does anyone else have this problem.

thanks
ed croxford
e...@wrld.com

 

Re:informix primary key


Why do you need to use the primary key?

We've been using Delphi (1,2,3,5) with Informix and if you use TQuery you
don't need to use any primary key. The database optimizer that parses the
query is on charge of using the indexes for speed up the access time, as
long as you use an appropiate SQL syntax.

--
Ing. Eduardo Martnez Ocampo
Chief Of Information Systems
Industria Envasadora de Quertaro, S.A. de C.V.
The Coca-Cola Canning Plant
eduar...@ieqsa.com.mx

Other Threads