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