Posted by Joseph on 09/30/05 08:36

Hi,
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/General-Discussions-filter-DELETE-ftopict259743.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=895190

• Next in forum: Trouble with SPROC
• Prev in forum: Re: Howto set Access Recordsource onto a "select" sproc
• Thread view: filter for DELETE

[Reply to this message]