数据库 access2000 (win98 下创建的)
vb6.0
语句: insert into 表 (renyuan,mima,quanxian) values ('aa','bb','cc')
以上字段是文本类型在程序里运行时候 提示:insert into 语句错误
复制到access 的查询分析器里 就可以执行请高手指教
vb6.0
语句: insert into 表 (renyuan,mima,quanxian) values ('aa','bb','cc')
以上字段是文本类型在程序里运行时候 提示:insert into 语句错误
复制到access 的查询分析器里 就可以执行请高手指教
解决方案 »
- SQL的FORMAT与Between组合用法??
- mdi子窗体体如何实现只能最大化,不能还原呀?
- 我在msflexgrid中单击可以使得选中的行都变为蓝色,但是当我在程序中给msflexgrid添加数据后,想要添加的一行变为蓝色,但却怎么试都不行
- 1用ado用vb6.0怎么data控件和dbgrid控件怎么连接不上access 2000但是可以连上access老的版本,
- form1.show()与load form1的区别???
- 关于RS.Find的语法
- 请问winsock如何动态加载
- qingfengljh(清风) 请说详细点
- 请问,怎样动态生成和删除控件?
- VB中,怎样发送电子邮件的“附件”?最好贴源程序!
- [还是不懂~~~]如何读取某一个word文档内容,并依次保存到一个数组中去(以回车为分隔)?
- 最基本的问题
INSERT INTO 语句的语法错误
This commonly occurs when your field name is a reserved word (see scenario 1 above). Adjust your field names and SQL statement accordingly and you should avoid the problem. If you can't adjust your fieldnames you can use [ ] s to delimit the field names, eg INSERT INTO table1
([field], [password])
VALUES ('value1', 'value2')
Scenario 2b - Syntax error in UPDATE statement.
This has the same cause as Scenario 2a immediately above. Scenario 3a - Syntax Error (Missing Operator)
This is commonly caused when some value that you are trying to SELECT/UPDATE etc contains a single quote . The error that you receive looks like: Microsoft JET Database Engine (0x80040e14)
Syntax error (missing operator) in query expression 'Name = 'O'Malleys''.
Because of the presence of the ' in the name O'Malleys the database engine thinks that you are constructing a WHERE clause like: WHERE name = 'O'
and doesn't know what to do with the rest of the name (Malleys). To solve this problem you need to use the Replace() function and replace all single quotes with two single quotes. It is recommended that you put the Replace() function above into a user-defined function and call as necessary within your page. Click here for an example of such a function. Scenario 3b - Syntax Error (Missing Operator) - incorrect delimiters
This error can also be caused when attempting an INSERT or UPDATE SQL statement and you have used incorrect delimiters.