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.
MySQL queries |
|
1 |
SELECT SUM(money) FROM mytable where esoda = 'ΕΣΟΔΑ' |
Jabaco Source |
|
1 |
Debug.Print System.getProperty("file.encoding")
|
Jabaco Source |
|
1 |
System.setProperty("file.encoding","UTF-8") |
This post has been edited 2 times, last edit by "fomaxrge" (Sep 30th 2012, 9:05pm)
Jabaco Source |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
Option Explicit Public Sub Form_Load() 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:" & path & dbname, "sa", "") a = InputBox("Search for:") qry = "SELECT * FROM mytable WHERE esoda = '" & a & "';" st = conn.createStatement() rs = st.executeQuery(qry) rs.next Debug.Print rs.getString("esoda") End Sub |
This post has been edited 2 times, last edit by "fomaxrge" (Oct 1st 2012, 4:46pm)
Quoted
do you have any idea what i have to do?
Quoted
java#lang#Class.forName("org.h2.Driver")
conn = DriverManager.getConnection("jdbc:h2:mysql://localhost:3306/my_api_2012", "root", "")
Quoted
a = "ΕΣΟΔΑ"
Quoted
How ever I just realized that if you copy/paste 'ΕΣΟΔΑ' into the Jabaco code editor it returns '?S???' !?
This post has been edited 1 times, last edit by "Dani" (Oct 1st 2012, 5:05pm)