从SQL到Access的语句转换
SET NOCOUNT ON; INSERT INTO tblpop3Mail(UserID,BodyText,CC,Encoding,FromAddress,FromName,Priority,DateTimes,Subject,Size) VALUES(104,'
','none','0','','','','Sun, 21 Jul 2002 14:49:9 -0800','学习计划表','34345');Select @@IDENTITY AS NewID;
这个SQL本来是用SQL Server作的,但是我现在想把代码改成是ACCESS的,请问怎么作,代码如下:
sql="SET NOCOUNT ON;"
sql=sql&" INSERT INTO pop3Mail(UserID,BodyText,CC,Encoding,FromAddress,FromName,Priority,DateTimes,Subject,Size) VALUES(" & UserID & _
",'"& strBodyText & _
"','"& strCC & _
"','" & strEncoding & _
"','"& strFromAddress & _
"','"& strFromName & _
"','"& strPriority & _
"','"& strDate & _
"','"& strSubject & _
"','"& strSize & _
"');"
sql=sql & "Select @@IDENTITY AS NewID;"
Set RsMail=oConn.execute (sql)
NewID = RsMail("NewID")
整个语句可以执行,但是我不知道最后那个NewID这个句字在Access里面怎么实现,因为在上面的代码里面需要用到这个NewID,我看过Sql Server的帮助,没有怎么弄明白,而且在Access好像不能在一个RS里面执行两个SQL语句,不知道是不是这样,
闲人勿扰,谢谢