Re: [Gambas-user] Datasource.Filter does not work

2014-11-08 Thread Martin McGlensey
Thanks, Bruce. That worked. Suggest they update the documentation to show Datasource.Filter = db.Subst(Field 1, Text) instead of Datasource.Filter = string. That may save someone else a few hours of debugging. Regards, Marty

Re: [Gambas-user] Datasource.Filter does not work

2014-11-08 Thread T Lee Davidson
On 11/08/2014 09:29 AM, Martin McGlensey wrote: Thanks, Bruce. That worked. Suggest they update the documentation to show Datasource.Filter = db.Subst(Field 1, Text) instead of Datasource.Filter = string. That may save someone else a few hours of debugging. Done.

[Gambas-user] Datasource.Filter does not work

2014-11-06 Thread Martin McGlensey
Hello, Using Gambas 3.6.1 on Ubuntu 12.04. I have a datatable called tblUsers with the following columns: Record_No, User, Password and last_Update. Record_No is the primary index. I have verified that there are two records in the datatable. Have the following code:

Re: [Gambas-user] Datasource.Filter does not work

2014-11-06 Thread Benoît Minisini
Le 06/11/2014 22:04, Martin McGlensey a écrit : Hello, Using Gambas 3.6.1 on Ubuntu 12.04. I have a datatable called tblUsers with the following columns: Record_No, User, Password and last_Update. Record_No is the primary index. I have verified that there are two records in the datatable.

Re: [Gambas-user] Datasource.Filter does not work

2014-11-06 Thread B Bruen
On Thu, 6 Nov 2014 16:04:33 -0500 Martin McGlensey mmcg29...@frontier.com wrote: Hello, (snipo) Now further down in a sub login.Filter = User = txtLogin.Text, where txtLogin.Text = Marty, I get query failed, unknown column 'Marty' in where clause The error ypu are reciving is correct.