Ocke Janssen wrote:
Hi Drew,
On 21.01.09 04:08, Drew Jensen wrote:
Hi all,
Question on this entry in the pool table:
"more intelligent deletion of table data (don't delete every single
record, but the set of records described by the current filter in the
table data view)"
Wondering what this is getting at.
Currently:
I open a dataview for a table.
Set a filter, limiting the records being displayed.
Click in the upper left corner to select the entire table.
All records currently displayed are deleted.
Those records not displayed (those not meeting the filter criteria )
are not deleted.
What am I missing?
The problem is that the rows are deleted ony by one. This isn't really
fast. What else should be used? We could create a delete statement
with a where condition which deletes all records at once. So the
difference is today we generate n statements, but we could do the same
job with one statement.
- oj
Morning,
AH, darn, yes that is in that statement isn't it.
First thing that comes to mind now is - is this really a question...LOL
Are you talking about adding a menu item / toolbar button for 'delete
all' records then, or just catching the fact that all records in the
dataview are selected?
Also would this new approach be extended to include where a user
directly selects a sub-group of records to delete so that the statement
might be something like:
DELETE FROM "Table" WHERE "RowIdentifier" in ( .....)
Best wishes,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
