[Gambas-user] automatic completion of textbox with mysql data

[Vassilis K]

I'm trying to make a routine that fills a dropdown menu of a textbox OR
fills a listbox with data taken from mysql, with every keypress.
So if the 1st key pressed is A it shows all data from A, if the second
key pressed is b it shows only the data from Ab etc..

I have made a few efforts with "Left$":

rs33 = MODMain.$Con.exec("select * from Aplianikis where Left
$(Eponimia,1) = '" & Left$(tEponimia.Text, 1) & "'")
ListBox1.Add = rs33!Eponimia

but it fails with error:

"Query failed: FUNCTION Apodeixi1.Left$ does not exist"

----

Is there a simple way to use automatic completion in a program?