Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filtering duplicate record in a table
Message
 
To
07/01/2003 02:42:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00738664
Message ID:
00738970
Views:
22
if you have an index on the animal type (TAG="TypeAnimal")
then (in addition to others), you could:
do while seek("dog","MyTable","TypeAnimal")
delete in MyTable
enddo
>Hey guys,
>
>I'm having a problem regarding on how am I going to delete records in a same table if that record already exist. Here's the situation
>
>for example I have a Table called myTable
>
>and this table have a record of.. lets say
>
>dog
>cat
>chicken
>goat
>cow
>dog
>cat
>
>how can I delete the duplicate record if those records belongs in a same table.
>
>Another problem is what is the syntax in subtracting two time entries.
>
>ex. I want to get the minutes difference of 18:30 to 08:00.
>
>Thanks a lot.
Imagination is more important than knowledge
Previous
Reply
Map
View

Click here to load this message in the networking platform