Ado programming error idispatch Error #3092

Idispatch Error #3092

When using ADO to access the database, one of the reasons for the idispatch Error #3092 error is that reserved keywords are used in SQL statements.

For example, this error occurs if the table name is user.

For example:

Error #3092: insert into acc_record (loginname, password) values ('abc', '123 ')

Success: insert into acc_record (loginname,[Password]) Values ('abc', '123 ')

 

Another example is:

Error #3092:Update table set value = '53. 74 'Where id = 100003

Success:Update table set
Table. Value= '53. 74' where id = 100003