do you use a collate sequence other than MACHINE?
>
>Thanks for your interest in helping.
>
>The fields are Field1 C(12) and Field2 C(16)
>and the index is Field1 + Field2.
>
>The seek uses Memvar1 + memva2. Both memvars are previously converted with
a padr() function to be the correct length for each.
>
>The table accepts the insertion of the duplicated value without an errror
message.
>
>When I use and SQL the duplictes show up. Same as with a broewse with
'nooptimze'. If I don't use 'nooptimize' in the browse the duplicates don't
show.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement