Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remove Duplicate Rows
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Remove Duplicate Rows
Miscellaneous
Thread ID:
01321346
Message ID:
01321346
Views:
44
I have a table with this structure:
Sec Tp Title                         Table      Field
---------------------------------------------------------
    CR cash balance between 300.rpt  trades     tradedate
    CR cash balance between 300.rpt  trades     valuedate
    CR cash balance between 300.rpt  cust       acctname 
    CR cash balance between 300.rpt  trades     conf_num 
    CR cash balance between 300.rpt  trades     product  
    CR cash balance between 300.rpt  trades     quantity 
    CR cash balance between 300.rpt  trades     price    
    CR cash balance between 300.rpt  trades     ext_price
    CR cash balance between 300.rpt  trades     productbal
    CR cash balance between 300.rpt  trades     cash_bal  
3.1 CR invoice prior posting.rpt     trades     product   
3.1 CR invoice prior posting.rpt     trades     quantity  
3.1 CR invoice prior posting.rpt     tranfile   tranquant 
3.1 CR invoice prior posting.rpt     prods      prodesc   
3.1 CR invoice prior posting.rpt     trades     price     
3.2 CR open customer positions.rpt   trades     tradedate 
3.2 CR open customer positions.rpt   trades     tradetype 
3.2 CR open customer positions.rpt   trades     product   
3.2 CR open customer positions.rpt   trades     quantity  
3.2 CR open customer positions.rpt   trades     price     
3.2 CR open customer positions.rpt   trades     net_amount
3.2 CR open customer positions.rpt   trades     cash_bal  
3.2 CR open customer positions.rpt   trades     conf_num  
3.2 CR open customer positions.rpt   trades     productbal
3.2 CR open customer positions.rpt   trades     valuedate 
How do I remove the duplicate rows?
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Next
Reply
Map
View

Click here to load this message in the networking platform