Hey guys., i am trying to do a simple addnew, update and i am getting this error.,can any one help me out please.
This is the code thats causing the error:
sql2="select * from dattbl_reports"
rs2.Open sql2,conn,3,3
rs2.AddNew
->rs2.Update
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-3.23.49-nt]You have an error in your SQL syntax near 'DEFAULT VALUES' at line 1
syntax near 'DEFAULT VALUES' at line 1
Thanks in advance!
This is the code thats causing the error:
sql2="select * from dattbl_reports"
rs2.Open sql2,conn,3,3
rs2.AddNew
->rs2.Update
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][ODBC 3.51 Driver][mysqld-3.23.49-nt]You have an error in your SQL syntax near 'DEFAULT VALUES' at line 1
syntax near 'DEFAULT VALUES' at line 1
Thanks in advance!