Here is a classic routine for finding duplicates. It has not been tested with
null fields.
//
// Method: DuplicatesToSet
//Search the current selection for duplicate values in a
field.
//
// INPUT1: Pointer - to field to
correction:
I meant to say, you can't fix records one by one if there are duplicates
remaining in the database.
> you can't assign a new value to the first found duplicate because it is a
> duplicate nonetheless.
**
4D Interne
I don't feel like I have enough information to write a code snippet,
but here are a few thoughts:
1.
I suppose you are aware of DISTINCT VALUES.
but if you suspect that the indexes are somehow corrupt,
you can no longer trust the command either.
2.
the duplicates could be null.
by definition,
4d_tech
>> or, via email, send a message with subject or body 'help' to
>> 4d_tech-requ...@lists.4d.com
>>
>> You can reach the person managing the list at
>> 4d_tech-ow...@lists.4d.com
>>
>> When replying, please edit your Subject line so it
plying, please edit your Subject line so it is more specific
> than "Re: Contents of 4D_Tech digest..."
>
>
> Today's Topics:
>
> 1. Re: [SPAM] Image from print form (Keisuke Miyako)
> 2. Finding duplicates (St
entSelection)
End if
// end of method
-Ursprüngliche Nachricht-
Von: 4D_Tech <4d_tech-boun...@lists.4d.com> Im Auftrag von Stephane Potvin via
4D_Tech
Gesendet: Donnerstag, 17. März 2022 03:25
An: 4d_tech@lists.4d.com
Cc: Stephane Potvin
Betreff: Finding duplicates
Hello,
I think you need to be more specific:
what do you mean by "duplicate"
what do you mean by "work the way I want"
I am looking for a simple a method to find duplicates.
A method that would show only the duplicates if they exist or return a message
if there are no such duplicates.
I already looked
Hello,
I am looking for a simple a method to find duplicates.
A method that would show only the duplicates if they exist or return a message
if there are no such duplicates.
I already looked in the 4D doc but found nothing that wakers the way I want.
Thank you,
Stephane
**
8 matches
Mail list logo