How to delete a record from "rstemp"?

Results 1 to 2 of 2

Thread: How to delete a record from "rstemp"?

  1. #1
    Wim Hufkens Guest

    Default How to delete a record from "rstemp"?

    After a query, I&#039ve got something in "rstemp".<BR>How can I delete a record from it?<BR>For example:<BR>DO UNTIL rstemp.eof<BR> if rstemp(2)="text" then <BR> &#039delete this record =&#062; How?<BR> rstemp.movenext<BR>LOOP<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: How to delete a record from

    There are two ways to do this, and my personal preference is to do the direct SQL code:<BR><BR> DELETE from [your table] WHERE [your column] = &#039text&#039<BR><BR>That would go through the entire table, just like your loop does, and delete all rows that have &#039text&#039 in the column you&#039re searching for. That&#039s by far the best and fastest way to do what you want, especially on larger tables.<BR><BR>However, you can just do rstemp.delete, I think.<BR><BR>Hope this helps.<BR><BR>Ben

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts