> 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
------------------------------------------------------------------------------
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
