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. Have the following code: > > > > Login.Connection = hConn > > Login.Table = "tblUsers" > > Login.Sort "User" > > > > > > This populates two datacontrols within the datasource container Login. That > works because I see the data in the datacontrols and it is correct. I know > the value 'Marty' is in the field 'User' in the table. > > > > 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" > > > > This syntax used to work as I have it in other modules that I have tested > previously. Now they also do not work as before. The Wiki says the syntax is > like the where clause. So it should work as I have written it. Where have I > gone wrong? > > > > Thanks, > > Marty >
Please provide your project. Regards, -- Benoît Minisini ------------------------------------------------------------------------------ _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
