You are not logged in.

Search results

Search results 61-80 of 88.

Dear visitor, welcome to Jabaco - Community. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

Monday, October 1st 2012, 4:17pm

Author: fomaxrge

Mysql SUM does not return something to me

do you have any idea what i have to do? Is it it strange that is returns Greek and make comparison with that strings to me, but does not return a where selection? **i tried your code but it returns java.lang.ClassNotFoundException: org.h2.Driver on me** Dim conn As Connection Dim qry As String Dim st As java#sql#Statement Dim rs As ResultSet Dim a As String java#lang#Class.forName("org.h2.Driver") conn = DriverManager.getConnection("jdbc:h2:mysql://localhost:3306/my_api_2012", "root", "") a = "Ε...

Sunday, September 30th 2012, 11:44am

Author: fomaxrge

Mysql SUM does not return something to me

i did ... Debug.Print System.getProperty("file.encoding") and returns ... cp1253 utf-8 **the strange is when i make a selection for example** select * from esoda_exoda and then... variable=Data.get.... if variable='ΕΣΟΔΑ' ...do something if variable='ΕΞΟΔΑ'... do something else IT WORKS PERFECT. But when i have as i told you a WHERE... or print it to msgbox it returns NOTHING! so as i suppose it takes my data from db and check them but it can not do the opposite. Do you have any idea please? I t...

Friday, September 28th 2012, 11:28am

Author: fomaxrge

msgbox before close form

Dani i can see my missing classes with red color when i press F1. What do you propose to do with them? to hit the 'clean' button

Friday, September 28th 2012, 11:26am

Author: fomaxrge

Mysql SUM does not return something to me

Dani i found what the problem is, but i can not find the solution. when i make a selection for example SELECT SUM(money) FROM mytable where esoda = 'esode' everything is ok but when i make a selection like SELECT SUM(money) FROM mytable where esoda = 'ΕΣΟΔΑ' with Greek world ΕΣΟΔΑ It returns NULL My collation is utf-8 general ci WHAT AM I DOING WRONG?

Thursday, September 27th 2012, 4:37pm

Author: fomaxrge

msgbox before close form

Dear Dani i did it and it works BUT i have too many missing classes what should i do with them?

Thursday, September 27th 2012, 4:30pm

Author: fomaxrge

Mysql SUM does not return something to me

Am i doing something wrong with the this statement ? Set Data = Order.executeQuery("SELECT SUM(money) FROM mytable where esoda = 'ΕΣΟΔΑ' ORDER BY mydate")

Thursday, September 27th 2012, 10:52am

Author: fomaxrge

msgbox before close form

You mean to add this one ? http://www.jabaco.org/board/p3044-comman…r.html#post3044. Is there a possibility to have problem with my version after ADD? Missing classes and other?

Wednesday, September 26th 2012, 9:21am

Author: fomaxrge

msgbox before close form

which framework do you suggest after this one to upload? So to work your code

Wednesday, September 26th 2012, 7:25am

Author: fomaxrge

msgbox before close form

i tried your example but when i press "x" nothing happening. my last framework is Jabaco200910070500.jar because as i heard it is better to have size bigger that 500 kb

Tuesday, September 25th 2012, 1:44pm

Author: fomaxrge

msgbox before close form

Hi Dani, thank again for you help. It is very good that there are people like you that help all of us that we are at our first steps. I tried your solution but nothing happened. Have you got any idea what am i doing wrong?

Tuesday, September 25th 2012, 6:47am

Author: fomaxrge

msgbox before close form

Hi again could you please help me how can i have a msgbox ask before close form (when pressed "X") I was trying something like this Private Sub Form_Unload(Cancel As Integer) If MsgBox("Are you sure you want to quit?", vbYesNo + vbQuestion, "Unload Test") = vbYes Then Call End End If End Sub but nothing happened

Monday, September 10th 2012, 9:05am

Author: fomaxrge

2 error goto handlers in one sub

hi again i need your help please. I want to have 2 error goto handlers in one sub but if i use a code like this returns that "Resume DoCalc:" expected end of statement what i have to do? OnErrorGoTo ErrHandler1 IfNot Exists(BaseDirectory +"\ARCHIVE")Then _ MkDir BaseDirectory +"\ARCHIVE" DoCalc: OnErrorGoTo Errhandler2 intvalue1 =12 intvalue2 =0 intvalue3 = intvalue1 / intvalue ExitSub ErrHandler1: Call MsgBox("Error making directory - "& Err.Number & vbCrLf & Err.Description, vbExclamation, App...

Wednesday, September 5th 2012, 11:26am

Author: fomaxrge

SELECT * FROM login where user=combobox1.text

Hi again i do not know why, but whatever i put in search field, returns no result. Imagine that i am searching from google for example "jabaco sql select" so to send me on this page. Thank you again

Tuesday, September 4th 2012, 4:59pm

Author: fomaxrge

SELECT * FROM login where user=combobox1.text

Could you please help me how to make a syntax of this query because i can not find a solution? Set Data = Order.executeQuery("SELECT * FROM login where user=combobox1.text;") Thank you very much

Tuesday, August 28th 2012, 10:20am

Author: fomaxrge

i can not see my pictureboxes and images

Hi again i would like to ask you something. When i put a picturebox or an image on a button that is png i can not see it. I can see it only when the program runs. Is there a way to see them?

Friday, August 24th 2012, 3:41pm

Author: fomaxrge

ComboBox1.ListIndex=-1

IT WORKS!!!! thank you very much *Even though i do not not what exactly .parent does i will try to find a tutorial see. Thank you again

Friday, August 24th 2012, 2:57pm

Author: fomaxrge

ComboBox1.ListIndex=-1

there is no other way / code to make the pointer go to the combobox with the first item? For example something like if the value = "empty" (that is my first item) Sorry if am tiring but i am trying to make my reset button work and i am confused

Friday, August 24th 2012, 11:16am

Author: fomaxrge

ComboBox1.ListIndex=-1

Hi Dani thank you for the userfull link. It helped me a lot to understand the frameworks. But i have another question yet. How can i change the code Public Property Let ListIndex(val As Integer) If val > 0 And val < ListCount Then Call Parent.setSelectedIndex(val) End If End Property to something like this? Public Property Let ListIndex(val As Integer) If val >= -1 And val < ListCount Then Call Parent.setSelectedIndex(val) End If End Property so to use it on my program

Thursday, August 23rd 2012, 11:25am

Author: fomaxrge

Jabaco Missing Classes - Help!

You can download and install again jabaco and add there all your forms and modules one by one. I works for me. I hope i helped you

WoltLab Burning Board