|
Home > Archive > Getting Started with dBASE > November 2006 > Syntax
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Michel PAIN 2006-11-03, 5:12 am |
| Hi,
I want to apply a filter on a table including field "QTE" as Stock-Quantity and field "MINI" as Stock-minimum
the filter should be : all rows with QTE <= MINI
row.filter = ("qte <= mini") ==> operation not applicable
what is the correct syntax ?
thanks
| |
| Jean-Pierre Martel 2006-11-03, 7:12 pm |
| In article <27gR6Ox$GHA.2036@news-server>, michel.pain@free.fr says...
> row.filter = ("qte <= mini") ==> operation not applicable
If you mean "form.rowset.filter", you can't compare fields in a filter.
As an alternative, use sql:
q = new query()
q.sql = 'select * from My_Table where qte <= mini'
q.active = true
Jean-Pierre Martel, editor
The dBASE Developers Bulletin
Blue Star dBASE Plus Core Concepts Graduate
| |
| Michel PAIN 2006-11-04, 12:12 am |
| Jean-Pierre Martel Wrote:
> In article <27gR6Ox$GHA.2036@news-server>, michel.pain@free.fr says...
>
> If you mean "form.rowset.filter", you can't compare fields in a filter.
>
> As an alternative, use sql:
>
> q = new query()
> q.sql = 'select * from My_Table where qte <= mini'
> q.active = true
>
> Jean-Pierre Martel, editor
> The dBASE Developers Bulletin
> Blue Star dBASE Plus Core Concepts Graduate
Merci beaucoup
M.Pain
| |
| Jean-Pierre Martel 2006-11-05, 12:15 am |
| In article <sjnpLi8$GHA.2036@news-server>, michel.pain@free.fr says...
>
> Merci beaucoup
De rien, monsieur Pain.
Jean-Pierre Martel, editor
The dBASE Developers Bulletin
Blue Star dBASE Plus Core Concepts Graduate
| |
|
| Would not "SET FILTER TO QTE<=MINI" work ?
Dom
Michel PAIN Wrote:
> Hi,
> I want to apply a filter on a table including field "QTE" as Stock-Quantity and field "MINI" as Stock-minimum
> the filter should be : all rows with QTE <= MINI
> row.filter = ("qte <= mini") ==> operation not applicable
> what is the correct syntax ?
> thanks
|
|
|
|
|