#126 Error: 无效的 SQL语句；期待 'DELETE'、'INSERT'、'PROCEDURE'、'SELECT'、或 'UPDATE'。

[Anonymous]

Application version: 2.5.9.813

Steps to reproduce: Running this SQL:

INSERT INTO HDLModbuTest(slaveAddress, startAddress, numberOfPoints, slavetype, CreateTime, ModifyTime, CreatePeople, ModifyTimePeople, sort, PlanId, Deleted, TestName)
VALUES (1, 1, 2, 0, '2023/11/08', '2023/11/08', 'admin', 'admin', 5,1, 0, '5.MCU运行指示灯测试')

Expected results:

Actual results: EOleException: 无效的 SQL语句；期待 'DELETE'、'INSERT'、'PROCEDURE'、'SELECT'、或 'UPDATE'。

Additional Information: Windows 10 Pro / ACE driver version 16.0

[Marciel Degasperi]

Thanks for reporting.

I tested your SQL and it worked as expected. I think you selected a part from the query when executing, this instructs MDB Admin to only execute the selected text, which may have caused the problem. See the images for more details.