I found this code on the forums... WORKS GREAT! for searches.. Looking for EDIT and DELETE examples?
Unless you can only do that using SQL commands?
Dim Con As java#sql#Connection
Dim Order As java#sql#Statement
Dim Data As ResultSet
'Load the JDBC-ODBC driver
Class.forName "com.mysql.jdbc.Driver"
'Create connection to the database test
Set Con = java#sql#DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "mydbuser", "")
'Create a statement and send the command to the database
Set Order = Con.createStatement
Set Data = Order.executeQuery("SELECT * FROM users;")
'Print the result from the select statement
Do While Data.next()
java#lang#system.out.println(Data.getString("username"))
' MsgBox Data.getString("username")+Data.getString("usersurname")
Loop
'Was hoping someone would now how to edit data this way?
'===================================================
Set Order = Con.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE)
Set Data = Order.executeQuery("SELECT * FROM users Where username = 'eben';")
Data.next
Data.updateString("username","babes")
Data.updateRow
'===================================================
'Close the connection
Con.close