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
