Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete duplicate records
Message
From
27/11/2006 17:01:51
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01172620
Message ID:
01172769
Views:
19
Yes, but even you have one record it will found that record? :)

>No, this just seeks the first one and deletes that. The flag gets you out of loop. And he doesn't want del all dupes -just 1 out of 3 (but it assumes there are always 3, as I said)
>
>>Don't you delete all records with that? He needed two records each key.
>>
>>>Metin
>>>
>>>Wouldn't it be best to set the order to the index Tariq had?
>>>
>>>Then (assuming always 3 of each or just 1), something like:
>>>
>>>

>>>SCAN
>>> llFound = .F.
>>> lnRecNo = RECNO()
>>> xdate = date
>>> xvoucher = voucher
>>> xtype = type
>>> xSeekKey = DTOC( date) + str( voucher) + Type && NOTE not ALLTRIM( Type) when used in key.
>>> Do while llFound
>>> If INDEXSEEK( xSeekKey, .T., "ThisTable", "TariqsIndex")
>>> Delete
>>> llFound = .T.
>>> Goto lnRecNo && Don't even think this necessary
>>> Endif
>>> EndDO
>>>EndSCAN
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform