还是老问题:报表行号的创建。
代码:
1,
Private Const strSql_ByOfsNo = "SELECT " & _
"aa.TaxpayID AS TaxpayID, " & _
"aa.TaxpayNo AS TaxpayNo, " & _
"aa.TaxCertNo AS TaxCertNo, " & _
"aa.TaxpayName AS TaxpayName, " & _
"aa.StatusDate AS StatusDate, " & _
"aa.StatusSign AS StatusSign, " & _
"aa.AmountInvoHold As AmountInvoHold, " & _
"aa.AmountMachBsns As AmountMachBsns INTO #NewTable " & _
"FROM msbsd_taxpay_base aa " & _
"WHERE (aa.OfficeNo = ?) " & _
"SELECT (SELECT SUM(1) FROM #NewTable WHERE #NewTable.TaxpayID<=bb.TaxpayID ) as 行号, " & _
"bb.TaxpayNo AS 纳税人编码, " & _
"bb.TaxCertNo AS 税务登记号, " & _
"bb.TaxpayName AS 纳税人名称, " & _
"bb.StatusDate AS 登记日期, " & _
"bb.StatusSign AS 营业状态, " & _
"bb.AmountInvoHold As 拥有发票张数, " & _
"bb.AmountMachBsns As 正常营业税控机数量 " & _
"FROM #NewTable bb "
2,
"SELECT " & _
"(SELECT SUM(1) FROM msbsd_taxpay_base WHERE TaxpayID<=aa.TaxpayID) as 行号," & _
"aa.TaxpayNo AS 纳税人编码, " & _"aa.TaxCertNo AS 税务登记号, " & _
"aa.TaxpayName AS 纳税人名称, " & _
"aa.StatusDate AS 登记日期, StatusSign AS 营业状态, " & _
"aa.AmountInvoHold As 拥有发票张数, " & _
"aa.AmountMachBsns As 正常营业税控机数量 " & _
"FROM msbsd_taxpay_base aa"
现象:1, 当对代码1进行操作的时候,完全的正确,可以达到意图。
1,当对代码2进行操作的时候系统报错。
2,CONNECTION 和command 都正确。
3,但是当操作recordset的时候就遇到了问题:“对象关闭,不允许操作。”
问题:
1,有哪位高手有成功的代码(不是简单的只对一个表进行操作的代码,要有两个表以上的条件查询)
2,请高手赐教。