Sir one more help, Public Sub Save_button_Click() Dim InsertDb As String 'Dim Dx As Date 'Format(Dx, "dd/mm/yyyy") InsertDb = "INSERT INTO name_tbl (adm, name, place, date_ad) VALUES ('" & (TextBox1.Text) & "','" & (TextBox2.Text) & "', '" & (TextBox3.Text) & "', '" & DateBox1.Value & "' )" MODMain.MyConn.Exec(InsertDb) message("Data saved") clear1 'Form2.Show
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 3:26 PM, Unaise EK <unais...@gmail.com> wrote: > 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 >> > -- 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