Consultor Eletrônico



Kbase 15179: Uniqueness bases ONLY on the indexed field for CISAM DSV
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   5/10/1998
Uniqueness bases ONLY on the indexed field for CISAM DSV


C-ISAM dataserver determines uniqueness bases ONLY on the indexed
field referred to in the WHERE clause.

C-ISAM queries will fail with the error that they're not unique.
For example the following will fail.

if can-find(cust where zip = 32010 and address = "33 Kelton St")
then display "unique".
else display "failed".

This is because the uniqueness is based only on the indexed field -
zip, and not the address field.

Progress Software Technical Support Note # 15179