OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

OOo and MySQL with Makro

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
traecker
Newbie
Newbie


Joined: 17 May 2005
Posts: 2

PostPosted: Sun May 22, 2005 10:46 am    Post subject: OOo and MySQL with Makro Reply with quote

Hallo,

I have and MySQL DB and have connect it with JDBC to OOo1.9.104
When I make and updatable ResultSet I can write Data to the DB with updateBoolean and updateDouble but when I try to write Data to an Varchar with updateString it dosn't work.

Here my Makro
Sub Main

Dim DatenbankKontext as Object
Dim Datenquelle as Object
Dim Verbindung as Object
Dim Statement as Object
Dim Resultset as Object

DatenbankKontext = createUnoService("com.sun.star.sdb.DatabaseContext")
Datenquelle = DatenbankKontext.getByName("Test")
Verbindung = Datenquelle.getConnection( "", "" )
Statement = Verbindung.createStatement()
Statement.ResultSetConcurrency = 1008
Resultset = Statement.executeQuery("SELECT * FROM bestart")

Resultset.next()
Resultset.updateString (6, "Test")
Resultset.updateDouble (13, 85,6)
Resultset.updateRow()
msgbox Resultset.getString (6)

Resultset.close()
Statement.close()
Verbindung.close()

End Sub

Can help me someone what I can try to solve the problem?

Thanks
Traecker
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group