Information générale
Catégorie:
Codage, syntaxe et commandes
>>>I want to remove duplicate VFP Memo records using SQL.
>>>
>>>Any ideas on how this is accomplished?
>>>
>>>*Can the code below be modified to remove duplicates in a memo field?
>>>
>>>USE URLS
>>>* Using SQL to remove dupicates (Thanks Naomi)
>>>SET ENGINEBEHAVIOR 90
>>>SELECT * FROM URLS GROUP BY Location INTO TABLE URLtemp
>>>SET SAFETY OFF
>>>CLOSE TABLES ALL
>>>COPY FILE URLtemp.DBF TO URLS.DBF
>>>CLOSE TABLES ALL
>>
>>Is Location the memo?
>
>No it is not, but I have solved the problem. Thank you Borislav
If you have oodles of data and problems with perf on such memo fields,
look into generating hashcodes/CRC for the memo field.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement