Search results
Search results 41-60 of 88.
hi dani! I tried to do your solution but i have "compile_error" and mark this... JBGrid1.Parent.getColumnModel().getColumn(2).setCellEditor(New DEFAULTCellEditor(ComboBox1)) Have you got any idea what i am doing wrong?
finally i found the solution but it appears when i dblclick on every cell. BUT I WANT TO HAVE THIS COMBOLIST ONLY IN (ROW,2)... so to have it when i double click only the "column = 2" not to ALL CELLS Does anybody know how can i do for example if col = 2 then.......COMBOLIST?
Have a nice week all of us! i would like to have a combobox in my JBGrid cell with row = 0 and col = 2 .... (0,2) that fills like that Set Data = Order.executeQuery("SELECT * FROM katigories WHERE katigories <> '***** ΚΑΜΙΑ *****' GROUP BY katigories ORDER BY katigories") Do While Data.next() katigories = Data.getString("katigories") ComboBox_katigoria.AddItem New ListCellData(katigories, all_katigories, False) Loop How can i do something like this?
Good afternoon ! Does anybody know why this does not work on me? If (Data.wasNull()) Then MsgBox "NULL" Else MsgBox "not NULL" End If i want to check if msql query is nothing because when i tried to compare with NULL OR "" nothing happened. *****when it finds a record it appears not NULL but when it does not find any record it does not appears the MsgBox "NULL" ******* Thanks in advanced
Hi everyone, i wonder is it easy to have scrollerbars in my combobox? I need vertical and horizontal as well. Thank you
combobox_change() was exactly what i was looking for. Thank you very much for your help and for your precious time you spend on my problem too. Have a nice day!
My exe that consists of many forms,images and many elements is only 1,46 MB. Did you do something wrong?
Hi again! I need your help please! I have a combobox that fills with the results of a mysql query. Is there a way to have a msgbox that appears the value of the selected item? I mean that... whenever i make a selection from combobox to appear a msgbox that tells ... "your selection is..." To help you, as i told you i have a combobox with categories (that fills from a mysql selection) and now i am trying to take the selected value of this combobox to make another mysql selection that fills my oth...
where do you want to appear it? Label, textbox? what ? for example if you have a label "test" then... test.Caption = now
so simple? you are perfect. both of them! thank you now back to work!
how can i use the Dani's function to do the opposite? 2012-08-06 to 06-08-2012?
YESSS it is working thank you thank you thank you!
hi again! Finally my problem did not solved. Can you please try this ... MsgBox Format("06-08-2012", "yyyy-MM-dd") to tell me what is coming back to you? to me it returns....0012-02-02???? Why ?
theuserbl and Dani thank you very much for your help. You helped me a lot.
Finally i did f something like this... 1> to_date.Text = Day(dd) &"-"& Month(mm) &"-"& Year(yyyy) 2> Set Data = Order.executeQuery("SELECT min(imerominia) FROM esoda_exoda") Do While Data.next() fromDate = Data.getString("min(imerominia)") from_date.Text = Format(fromDate, "dd-MM-yyyy") Loop ***the funny is, that all the dates i had were...*** 2012-08-06 2012-09-13 2012-09-17 2012-09-19 2012-09-21 2012-09-25 2012-09-26 2012-09-27 there is nowhere 2010-04-04 or 2004-04-10 in my table.
first of all thank you very much for your precious time you spend on my query. The above dates 04-04-0010 10-04-0004 are not included in my table. Also i want to format my imerominia variable that is used a mysql query in a loop for example.... Do while Data.next() ... imerominia=Data.getString("imerominia") imerominia = Format(imerominia, "dd-MM-yyyy") ... Loop also i was trying today to make something like this ... dateNow = Format(NOW, "dd,MM,yyyy") and returns me also a very strange date. 05...
Quoted from "Dani" Set Data = Order.executeQuery("SELECT DATE_FORMAT(imerominia, '%d-%m-%Y') FROM esoda_exoda order by imerominia") when i make SELECT DATE_FORMAT(imerominia, '%d-%m-%Y') FROM esoda_exoda order by imerominia into my mysql editor everything is fine but when i return to jabaco and make... Set Data = Order.executeQuery("SELECT DATE_FORMAT(imerominia, '%d-%m-%y') FROM esoda_exoda order by imerominia") Do While Data.next() imerominia = Data.getString("imerominia") java#lang#system.ou...
Quoted from "theuserbl" imerominia = Format(imerominia, "dd-MM-yyyy") in this case returns me always ... 04-04-0010 10-04-0004 04-04-0010 10-04-0004 04-04-0010 10-04-0004
Hello everybody! I need to use the format function to convert me date results from yyyy-mm-dd to dd-mm-yyyy BUT.... i use a function like this Public Function Format(d As Date, fmt As String) As String Dim df As New java#text#SimpleDateFormat(fmt) Format = df.format(d) End Function then call her like this.... Set Data = Order.executeQuery("SELECT imerominia FROM esoda_exoda order by imerominia") Do While Data.next() imerominia = Data.getString("imerominia") imerominia = Format(imerominia, "dd-mm...
Hi Dani finally this "seams" to solve my problem... DriverManager.getConnection( "jdbc:mysql://"+host+"/"+dbName+"?useUnicode=true&characterEncoding=UTF-8",user,pass); I would like to use H2 because it is very good solution as i read, but i have already create many tables in my database and i am scared of make any changes. Thank you very very much for your help. You make me understand what was happenig so to find the solution. Thank you very much again!
