Would you know what is wrong with my INSERT statement?
On ODBC connection to a Progress 9.1b I am trying to use an insert statement but getting systax error message:
the code is like this
SET rs2 = Server.CreateObject("ADODB.Recordset")
StrSQL2 = "INSERT INTO PUB.struc_subcc (id) VALUES (301)"
rs2.Open strSQL2, adocon
This is the error message,
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MERANT][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)
/local/corprep/addrule.asp, line 114
Is ther e a site or webpage where it address the specific issues with progress SQL?
Thanks in advance.
On ODBC connection to a Progress 9.1b I am trying to use an insert statement but getting systax error message:
the code is like this
SET rs2 = Server.CreateObject("ADODB.Recordset")
StrSQL2 = "INSERT INTO PUB.struc_subcc (id) VALUES (301)"
rs2.Open strSQL2, adocon
This is the error message,
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[MERANT][ODBC PROGRESS driver][PROGRESS]Syntax error (7587)
/local/corprep/addrule.asp, line 114
Is ther e a site or webpage where it address the specific issues with progress SQL?
Thanks in advance.