locating and deleting records in tables.

[kjspear]

Hello, I have set up a button with searches and deletes records that match a criteria. However, with TCursor, I can only delete the matching records on at a time by pressing the button. I

I would like to press the button only once and all the records that match the criteria all at one time.

How do I go about doing this?

Thanks
Kyle

 

[Langley]

The best way would be to use a delete query and a variable.

i.e.

Grab your variable from an unbound field, or picklist, or whatever. Then plug it into the delete query and run it.


var
MyVar string
qVar query
endvar

If someField.value = "" ; user types in criteria
then return ; don't want to delete ALL records - lol
else MyVar = someField.value ; variable assigned
endif

qVar =
Query

Table.DB | Computer |;only the field w/the Variable needed
Delete | ~MyVar |

EndQuery

if not qVar.executeQBE("riv:deleted.db&quot
then errorShow()
endIf

----------------------------------------------

That's it.

Mac