[Gambas-user] datasource filter

[Benoît Minisini]

> Hello,
> how can i set the filter property of a datasource for 2 fields.
> Example:
> 	filter where id =value and nprice>dat
> id and nprice are fields, and value and dat are variables
>
>
> I can filter one of them but not them together
>
> Thank you an d sorry for my little english
>

You can do that: the filter is a SQL where clause.

MyDataSource.Filter = DB.Subst("id = &1 AND nprice > &2", value, dat)

-- 
Benoît