I don’t know to write SQL command filter.
m_strQueryDelete.Format("DELETE FROM tab WHERE (Col1 = ’abc’ AND Col2
= ’abc’ AND ?????)"
example: ODBC found 100 records.
I need to delete first 90 records and to leave last 10 records.

Thank you

Joseph

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Client-filte...ict259609.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=894697

Is there a unique field in the table, where you could write a query
like:

DELETE FROM TAB WHERE UNIQUE_FIELD IN
(SELECT TOP 90 UNIQUE_FIELD FROM TAB WHERE (COL1= 'ABC' AND COL2='ABC'
AND ?????))

Good luck,
Tony Sebion


"Joseph" <UseLinkToEmail (AT) dbForumz (DOT) com> wrote