Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stuck with this Vdbase to Vfp conversion
Message
From
06/06/2002 16:14:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Stuck with this Vdbase to Vfp conversion
Miscellaneous
Thread ID:
00665672
Message ID:
00665672
Views:
53
Hello all

How to code this in vfp,coz i'm little weak with arrays.txs
               * Where there are dupes within a Quarterly <File Type> table
               * and the user has flagged one of the recs of a dupe set as a
               * non-error record, delete the other members of the dupe set.
               
               QIndexKey = key(tagno('CompSSNOEP'),'QorM')
               set filter to 'Dupe'$ErrFlag1+ErrFlag2.and.QorM->DeletFails
               count all to N
               if N>0
                   set fields to F1=&QIndexKey
                   GoodDupes = new array(N,1)
                   copy all to array GoodDupes
                   set fields to
                set filter to 'Dupe'$ErrFlag1+ErrFlag2.and..not.QorM->DeletFails
                   delete for GoodDupes.Scan( &QIndexKey ) > 0
                endif
               set filter to          
Next
Reply
Map
View

Click here to load this message in the networking platform