比如我sql="select top ? * from men where id=6 order by author desc"
mycmd.CommandText=sql
set mypar1 = mycmd.CreateParameter("num",19,1,1,num)
mycmd.Parameters.Append mypar1
mycmd.Prepared = true
set rs = mycmd.Execute
就会报select语句的错误
...全文
262打赏收藏
access中top ?怎么参数化
比如我sql="select top ? * from men where id=6 order by author desc" mycmd.CommandText=sql set mypar1 = mycmd.CreateParameter("num",19,1,1,num) mycmd.Parameters.Append mypar1 mycmd.Prepared = true set rs = mycmd.Execute 就会报select语句的错误