General information
Category:
Coding, syntax & commands
>>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only