one more thing - are you sure your key is marked as Candidate and not as
Unique
Arnon
>>I didn't see the reply I wrote - so forgive me if this is a duplicate msg
>>
>>do you use a collate sequence other than MACHINE?
>>
>>Arnon
>>
>>>
>>>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.
>
>Arnon, the collate sequence must be the default setting used by VFP5.0, I
have never dealt with the collate sequence. I'll look into this.
>Thanks,
>Art Castro
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only