问题描述Foxtalbe中的 SQL Command,定义了一个查询,用cmd.ExecuteNonQuery 返回值 每次都是 -1,output 了 cmd 的 sql 字符串,复制到 sql server 中正常查询无误
请问为啥 返回值是 -1 啊。
代码如下:
Dim cmd As New SQLCommand
cmd.C
cmd.CommandText = "S elect COUNT(*) From " & TbName & " Where [账套期间] >= '" & BeginMonthFirstDay & "' and [账套期间] <= '" & EndMonthLastDay & "' And ([审核人员] is null or [审核人员] ='')"
RemainCounter = cmd.ExecuteNonQuery
output 的 sql 代码
S elect * From 公用_收款明细 Where [账套期间] >= '2018-10-01' and [账套期间] <= '2018-10-31' And ([审核人员] is null or [审核人员] ='')