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
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.
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:
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.
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.