|
|
 | | From: | Mark Wood | | Subject: | Increased functionality in rowset.filter | | Date: | Tue, 7 Dec 2004 10:21:38 -0000 |
|
|
 | In a future release of dBase, I would like to see the ability to perform field vs field comparison within filters.
Eg (where "account_balance", "invoice_address" and "delivery_address" are fields and "rowDebtors" is a rowset) rowDebtors.filter := "invoice_address <> delivery_address and account_balance > 0"
granted a field "delivery_not_invoice" set to true/false would address the issue, but that is extra coding and gets less and less elegant the more comparisons of this type are made: the programmer could end up with more fields of this type than fields that hold 'real' data.
It would also be advantageous to incorporate support for some of the predicates such as Like, though I would find that less useful personally than the addition of field vs field comparison.
|
|
 | | From: | Ken Mayer [dBVIPS] | | Subject: | Re: Increased functionality in rowset.filter | | Date: | Tue, 07 Dec 2004 05:45:40 -0800 |
|
|
 | Mark Wood wrote: > In a future release of dBase, I would like to see the ability to perform > field vs field comparison within filters.
There's a bug report for this one, I believe.
QAID: 378
Ken
-- /(Opinions expressed are purely my own, not those of dataBased Intelligence, Inc.)/
*Ken Mayer* [dBVIPS] /Golden Stag Productions/ dBASE at goldenstag dot net http://www.goldenstag.net/GSP http://www.goldenstag.net/dbase
|
|
|