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)