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
Miscellaneous
Thread ID:
01321346
Message ID:
01321347
Views:
12
What is the definition of a duplicate here?

>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?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform