代码如下:strUser="wang"mySQL="INSERTINTO[user](user_UserID,user_Pin,user_FamilyName,user_Name)VALUES('"&strUser&"','"&"000000"&"','"&strUserFamily&"','"&strUserName&"')"...
代码如下:
strUser="wang"
mySQL="INSERT INTO [user] (user_UserID,user_Pin,user_FamilyName,user_Name) VALUES('" & strUser & "','" & "000000" & "','" & strUserFamily & "','" & strUserName & "')"
myRs.Open mySQL,myConn,1,3
mySQL="INSERT INTO [user] (user_UserID,user_Pin,user_FamilyName,user_Name) VALUES('" & strUser & "','" & "000000" & "','" & strUserFamily & "','" & strUserName & "')"
myRs.Open mySQL,myConn,1,3
mySql="SELECT @@IDENTITY as myAutoID"
myRs.Open mySQL,myConn,1,1
Dim myAutoID
myAutoID=myRs("myAutoID")
为什么
mySQL="INSERT INTO [user] (user_UserID,user_Pin,user_FamilyName,user_Name) VALUES('" & strUser & "','" & "000000" & "','" & strUserFamily & "','" & strUserName & "')"
myRs.Open mySQL,myConn,1,3
写两遍就可以返回正确的值,当然返回值也是加了2的。写一遍就返回Null呢。
user中有个增量字段id
请指教!
展开