Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't do a simple REPLACE command
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00305973
Message ID:
00308532
Views:
29
Thanks Jim, I will give that a try.

And Merry Christmas.

Elgin


>Elgin,
>
>Here's one suggestion that could be used. Assuming the table with dups is named Master.
>
>
>USE Master ORDER PrimaryKeyIndex IN 0 AGAIN ALIAS Master
>
>SELECT * FROM Dups ;
> ORDER BY TheExpressionThatYouWantToFindDupsOf ;
>  INTO CURSOR Dups
>SELECT Dups
>SCAN
>
>  * Check this record against the last record
>
>   * If this is a dup
>         * SEEK the Dups.PK in Master
>         * Increment the Master table field
>ENDSCAN
>
Elgin Rogers
Epic Solutions
www.epicsolutions.net
Previous
Reply
Map
View

Click here to load this message in the networking platform