You are not logged in.

adanny08

Beginner

  • "adanny08" started this thread

Posts: 14

Date of registration: Mar 4th 2009

  • Send private message

1

Monday, March 23rd 2009, 1:06pm

I am having data manipulation problems.can anyone help?

When using insert statements there is always an error:"java.sql.SQLException: Can not issue data manipulation statements with executeQuery()" but I am able to use select statements.I am using mysql.

This post has been edited 2 times, last edit by "adanny08" (Mar 23rd 2009, 3:58pm)

htillmann

Beginner

  • "htillmann" is male

Posts: 30

Date of registration: Feb 25th 2009

Location: Beverungen / Weser

Occupation: Softwareentwicklung

  • Send private message

2

Monday, March 23rd 2009, 9:08pm

SQL Data manipulation

Hi,

there's already a german thread about this, please take a look at:

Update auf Mysql DB

Jabaco Source

 
1
2
3
4

Public Function ExecuteUpdate(sql As String) As Integer
   Dim myStmt As java#sql#Statement = myCon.createStatement()
   ExecuteUpdate = myStmt.executeUpdate(sql)
End Function


You have to implement the source above to the JabacoFramework/VB/Database (Sourceforge)

I had some trouble to compile the complete framwork but you can copy the new file directly into the original JABACO jar-file.

Friendly regards

Hubertus

adanny08

Beginner

  • "adanny08" started this thread

Posts: 14

Date of registration: Mar 4th 2009

  • Send private message

3

Tuesday, March 24th 2009, 3:38pm

I need an updated jabaco jar file.

I understood what you were talking about but I could not add the file to the existing jar file.Please can you do it and send the jar file to me.Or please show me some other means.Thanks

Similar threads

Rate this thread
WoltLab Burning Board