请各位朋友帮一个忙

来源:百度知道 编辑:UC知道 时间:2024/05/31 20:53:40
strSQL= "INSERT INTO PSLogins(LoginID, Name, EmailAddress, " _
& "Department, Position,Birthday, HomePhone, QQ, HomeAddress," _
& " MobilePhone) values (" _
& "'" & TheLoginID &"', " _
& "'" & TheName &"', " _
& "'" & TheEmailAddress &"', " _
& "'" & TheDepartment &"', " _
& "'" & ThePosition &"', " _
& "'" & TheBirthday &"', " _
& "'" & TheHomePhone &"', " _
& "'" & TheQQ &"', " _
& "'" & TheHomeA

& "'" & TheLoginID &"', " _
& "'" & TheName &"', " _
& "'" & TheEmailAddress &"', " _
& "'" & TheDepartment &"', " _
& "'" & ThePosition &"', " _
& "'" & TheBirthday &"', " _
& "'" & TheHomePhone &"', " _
& "'" & TheQQ &"', " _
& "'" & TheHomeAddress &"', " _
& "'" & TheMobilePhone & "')
好象每一个值前都多了一个单引号
再一个是不是数据类型问题??

代码没有问题 提示什么错误 你要说出来
你字段类型 有控制好
是否为空值
LoginID 字段是不是自动生成的类型