P
pepsi-cola
Unregistered / Unconfirmed
GUEST, unregistred user!
以下SQL语句包括了table_main的所有字段，这些字段的数据类型都是字符型，
insert table_main
(ID, date, name, sex, time_in, time_out, company, supervisor, case, kind,
Injury_illness, Body_parts_affected, pos)
values
('I', 'd', 'n', 's', 'i', 'o', 'c', 's',
'c', 'k', 'I', 'B', 'p')
但执行时却总是报错：
General SQL error
[Microsoft][ODBC Micosoft Access 驱动程序] INSERT INTO 语句的语法错误
请问是怎么回事？
insert table_main
(ID, date, name, sex, time_in, time_out, company, supervisor, case, kind,
Injury_illness, Body_parts_affected, pos)
values
('I', 'd', 'n', 's', 'i', 'o', 'c', 's',
'c', 'k', 'I', 'B', 'p')
但执行时却总是报错：
General SQL error
[Microsoft][ODBC Micosoft Access 驱动程序] INSERT INTO 语句的语法错误
请问是怎么回事？