Vasilli, perhaps you want to try this one
rs33 = MODMain.$Con.exec("select * from Aplianikis where " & Left$(Eponimia,1) & " = '" & Left$(tEponimia.Text, 1) & "'") ListBox1.Add = rs33!Eponimia I hope this helps Regards Dimitris On Sat, Feb 13, 2010 at 1:18 PM, Vassilis K <vka...@otenet.gr> wrote: > 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 > ------------------------------------------------------------------------------ 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