Hi,
I have a mysql database, in which there is a table "m01city" which consists of:
city_id: AutoNumber
city_name: Varchar (25)
And this is my config.properties
#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/tds?characterEncoding=utf8
User=root
Password=
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true
#commands
sql.select_city=SELECT city_id, city_name FROM m01city WHERE city_id = ?
sql.insert_city=INSERT INTO m01city (city_id, city_name) VALUES (null, ?)
sql.update_city=UPDATE m01city SET city_name = ? WHERE city_id = ?
sql.delete_city=DELETE FROM m01city WHERE city_name = ?
How do I "Insert Record", "Update Record", "Delete Record" using DBRequestManager?
For "Select Record" i use this syntax and it works:
Sub Get_City()
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "select_city"
cmd.Parameters = Array As Object()
reqManager.ExecuteQuery(cmd, 0, Null)
End Sub
Could someone help me?
-Andri-
I have a mysql database, in which there is a table "m01city" which consists of:
city_id: AutoNumber
city_name: Varchar (25)
And this is my config.properties
#Lines starting with '#' are comments.
#Backslash character at the end of line means that the command continues in the next line.
DriverClass=com.mysql.jdbc.Driver
JdbcUrl=jdbc:mysql://localhost/tds?characterEncoding=utf8
User=root
Password=
ServerPort=17178
#If Debug is true then this file will be reloaded on every query.
#This is useful if you need to modify the queries.
Debug=true
#commands
sql.select_city=SELECT city_id, city_name FROM m01city WHERE city_id = ?
sql.insert_city=INSERT INTO m01city (city_id, city_name) VALUES (null, ?)
sql.update_city=UPDATE m01city SET city_name = ? WHERE city_id = ?
sql.delete_city=DELETE FROM m01city WHERE city_name = ?
How do I "Insert Record", "Update Record", "Delete Record" using DBRequestManager?
For "Select Record" i use this syntax and it works:
Sub Get_City()
Dim cmd As DBCommand
cmd.Initialize
cmd.Name = "select_city"
cmd.Parameters = Array As Object()
reqManager.ExecuteQuery(cmd, 0, Null)
End Sub
Could someone help me?
-Andri-
