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?
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
