Thanks, it is working On 25 May 2017 3:11 p.m., "Jorge Carrión" <sho...@gmail.com> wrote:
> Try > > Public Procedure AddList() > Dim ListQurey As String > Dim Lresult As Result > > ListQurey = "SELECT name FROM name_tbl" > Lresult = MODMain.MyConn.Exec(ListQurey) > 'If Lresult.Count > 0 Then > '* Do While Not Eof(Lresult)* > while Lresult.available > ListBox1.Add(Lresult!"name") > Lresult.MoveNext > wend > 'Endif > > End > > 2017-05-25 11:29 GMT+02:00 Unaise EK <unais...@gmail.com>: > > > this is my code for displaying data in listbox, but it did not working, > pls > > help > > > > Public Procedure AddList() > > Dim ListQurey As String > > Dim Lresult As Result > > > > ListQurey = "SELECT name FROM name_tbl" > > Lresult = MODMain.MyConn.Exec(ListQurey) > > If Lresult.Count > 0 Then > > * Do While Not Eof(Lresult)* > > ListBox1.Add(Lresult!"name") > > Lresult.MoveNext > > Loop > > Endif > > > > End > > > > > > > > <https://mailtrack.io/> Sent with Mailtrack > > <https://mailtrack.io/install?source=signature&lang=en&; > > referral=unais...@gmail.com&idSignature=22> > > > > On Thu, May 25, 2017 at 2:52 PM, Unaise EK <unais...@gmail.com> wrote: > > > > > can you give example for > > > DO WHILE NOT database EOF > > > > > > Loop > > > > > > > > > > > > > > > <https://mailtrack.io/> Sent with Mailtrack > > > <https://mailtrack.io/install?source=signature&lang=en&; > > referral=unais...@gmail.com&idSignature=22> > > > > > > On Thu, May 25, 2017 at 8:30 AM, PICCORO McKAY Lenz < > > > mckaygerh...@gmail.com> wrote: > > > > > >> there are the piece of code and here there's no secret: > > >> > > >> Public Function getItems() As Collection > > >> > > >> Dim $items As New Collection > > >> Dim itema, itemb as String = "something" > > >> > > >> $items.Add($itema, "item1") > > >> $items.Add($itemb, "item2") > > >> $items.Add(2, "cuantos") > > >> > > >> Return $items > > >> > > >> End > > >> > > >> here the previous code "bad programed" and when i swicht to collection > > >> gambas ide get slower after some time, the code was: > > >> > > >> Public Function getItems() As String[] > > >> > > >> Dim $items As New String[] > > >> Dim itema, itemb as String = "something" > > >> > > >> $items.Add($itema) > > >> $items.Add($itemb) > > >> > > >> Return $items > > >> > > >> End > > >> > > >> the gambas ide and the OS was not shutdown during 40 days, also the > > gambas > > >> ide was not quit in this period, and in that period i run the huge > data > > >> code of the 3 odbc bug with 100000 registers, after change the code to > > >> collection (each change are little before test) thje ide gambas get > > slow > > >> and does not run well.. > > >> > > >> this happened to my other partners in the job... i test also in debian > > >> jeesie and happened same! > > >> > > >> i noted that when alone user said something its like "nothigs its > > >> happened, > > >> its just bad programer" > > >> > > >> will need other to reports, but these other do not have time to make a > > >> little project and report that.. > > >> > > >> sqlite was severi broken until gambas 3.6 and must be rewrite for > gambas > > >> 3.8 > > >> > > >> now in gamba 3.9 ther's some doc-online problems with cache and some > > >> memory > > >> manage problems.. > > >> > > >> but for not specialized programmers its very difficult to debug, find > > and > > >> report LIKE THE QT problem.. > > >> > > >> > > >> > > >> Lenz McKAY Gerardo (PICCORO) > > >> http://qgqlochekone.blogspot.com > > >> > > >> 2017-05-24 17:01 GMT-04:30 Jussi Lahtinen <jussi.lahti...@gmail.com>: > > >> > > >> > Impossible to say anything without seeing the code, which causes the > > >> > problem. > > >> > > > >> > > > >> > Jussi > > >> > > > >> > On Thu, May 25, 2017 at 12:11 AM, PICCORO McKAY Lenz < > > >> > mckaygerh...@gmail.com > > >> > > wrote: > > >> > > > >> > > i change the odbc code for huge data to transport only two objects > > >> with a > > >> > > string, and i noted that gambas before hangs sometimes... so i > > >> discovered > > >> > > that when i used collections the memory management are very bad.. > > >> > > > > >> > > should i send a bug or where i start to see why this happened or > its > > >> only > > >> > > happened only to me! > > >> > > > > >> > > > > >> > > Lenz McKAY Gerardo (PICCORO) > > >> > > http://qgqlochekone.blogspot.com > > >> > > ------------------------------------------------------------ > > >> > > ------------------ > > >> > > Check out the vibrant tech community on one of the world's most > > >> > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > >> > > _______________________________________________ > > >> > > Gambas-user mailing list > > >> > > Gambas-user@lists.sourceforge.net > > >> > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > >> > > > > >> > ------------------------------------------------------------ > > >> > ------------------ > > >> > Check out the vibrant tech community on one of the world's most > > >> > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > >> > _______________________________________________ > > >> > Gambas-user mailing list > > >> > Gambas-user@lists.sourceforge.net > > >> > https://lists.sourceforge.net/lists/listinfo/gambas-user > > >> > > > >> ------------------------------------------------------------ > > >> ------------------ > > >> Check out the vibrant tech community on one of the world's most > > >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > >> _______________________________________________ > > >> Gambas-user mailing list > > >> Gambas-user@lists.sourceforge.net > > >> https://lists.sourceforge.net/lists/listinfo/gambas-user > > >> > > > > > > > > > > > > -- > > > M. Unaise. E.K > > > 9895687604 <098956%2087604> > > > Librarian, > > > (BLISc, MLIS) > > > JDT Islam Polytechnic College, > > > Vellimadukunnu. > > > > > > > > > > > -- > > M. Unaise. E.K > > 9895687604 > > Librarian, > > (BLISc, MLIS) > > JDT Islam Polytechnic College, > > Vellimadukunnu. > > ------------------------------------------------------------ > > ------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
