Hello all.
I get an error 3 (ERROR: current transaction is aborted, commands ignored until end of transaction block) whenever I try to create a table.
This code does not work:
[code]Dim S As String = “CREATE TABLE defaults_controller (server_ip character(20),ping_interval integer,activitysummary_update_interval integer,transaction_sync_interval INTEGER,serverport smallint,”
S = S + “noresponsetimeout smallint,disconnect_delay smallint,master_loginid character(50),master_pw character(30),corp_id INTEGER,site_id INTEGER PRIMARY KEY,device_cpu_serial CHAR(64),”
S = S + “ui_id INTEGER,user_pw CHAR(30),license_path CHAR(255),data_path CHAR(255),auto_print CHAR(1),langauge CHAR(25),date_format CHAR(10),in_debug_mode INTEGER,ip_update_interval INTEGER,”
S = S + “ip_update_retries INTEGER,resend_cmd_interval INTEGER,resend_cmd_max_retries INTEGER,listen_port INTEGER, mac_address CHAR(18) );”
db.SQLExecute(s)
[/code]
This code does - from the samples:
Dim S As String = "CREATE TABLE defaults_controller (server_ip character(20),ping_interval integer,activitysummary_update_interval integer,transaction_sync_interval INTEGER,serverport smallint,"
S = S + "noresponsetimeout smallint,disconnect_delay smallint,master_loginid character(50),master_pw character(30),corp_id INTEGER,site_id INTEGER PRIMARY KEY,device_cpu_serial CHAR(64),"
S = S + "ui_id INTEGER,user_pw CHAR(30),license_path CHAR(255),data_path CHAR(255),auto_print CHAR(1),langauge CHAR(25),date_format CHAR(10),in_debug_mode INTEGER,ip_update_interval INTEGER,"
S = S + "ip_update_retries INTEGER,resend_cmd_interval INTEGER,resend_cmd_max_retries INTEGER,listen_port INTEGER, mac_address CHAR(18) );"
mDB.SQLExecute(s) //(sql)
I don’t see what the difference is. Both are executing but only 1 works.
Any ideas what I am doing wrong?
Tim