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
Takk,
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
--
Ocke Janssen Tel: +49 40 23646 661, x66661
Dipl. Inf(FH) Fax: +49 40 23646 550
Sun Microsystems Inc.
Nagelsweg 55 mailto:[email protected]
D-20097 Hamburg http://www.sun.com/staroffice
Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1,
D-85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
