Deleting Duplicate Rows

[Ganesh Babu]

Hi

How to delete duplicate rows in a datawindow without using embedded SQL. Because
we using three backend ie SQL server, Oracle, Adaptive Server. Pls reply
immediately.

Thanks

Ganesh Babu T.R
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

[Simon Caldwell]

this.SetSort("<key column>")
this.Sort()
this.SetFilter('getrow() = 1 or <key column>[-1] <> <key column>[0]')
this.Filter()
this.RowsDiscard(1,this.FilteredCount(),Filter!)

"Ganesh Babu" <trga...@hotmail.com> wrote in message
news:7PB0tGE...@forums.sybase.com...