vb代碼:
Dim prm As ADODB.Parameter
Dim adocomm As ADODB.Command
Set adocomm = New ADODB.Command
Set adocomm.ActiveConnection = CN
adocomm.CommandText = "sp_Rep_Plan"
adocomm.CommandType = adCmdStoredProc
Set prm = adocomm.CreateParameter("@PlanCode_Fr", adVarChar, adParamInput, 20, Me.txtPlanCodeForm.Text)
adocomm.Parameters.Append prm
Set prm = adocomm.CreateParameter("@PlanCode_To", adVarChar, adParamInput, 20, Me.txtPlanCodeTo.Text)
adocomm.Parameters.Append prm
Set TmpRS = New ADODB.Recordset
Set TmpRS = adocomm.Execute
Set prm = Nothing
Set adocomm = Nothing----------------------------
存儲過程內容
SELECT *
into #abc
FROM table
ORDER BY Process2.ItemIDselect * from #abc--------------------------
問題是,如果將記錄插入到一個臨時表時,在vb調用ado去拿記錄時,就不出錯,但沒有記錄。
如果直接用以下的語句:
SELECT *
into #abc
FROM table
ORDER BY Process2.ItemID
再用vb去拿記錄時,就會有記錄出現?這是為什麼??請高手幫忙呀?這個問題急要呀。
Dim prm As ADODB.Parameter
Dim adocomm As ADODB.Command
Set adocomm = New ADODB.Command
Set adocomm.ActiveConnection = CN
adocomm.CommandText = "sp_Rep_Plan"
adocomm.CommandType = adCmdStoredProc
Set prm = adocomm.CreateParameter("@PlanCode_Fr", adVarChar, adParamInput, 20, Me.txtPlanCodeForm.Text)
adocomm.Parameters.Append prm
Set prm = adocomm.CreateParameter("@PlanCode_To", adVarChar, adParamInput, 20, Me.txtPlanCodeTo.Text)
adocomm.Parameters.Append prm
Set TmpRS = New ADODB.Recordset
Set TmpRS = adocomm.Execute
Set prm = Nothing
Set adocomm = Nothing----------------------------
存儲過程內容
SELECT *
into #abc
FROM table
ORDER BY Process2.ItemIDselect * from #abc--------------------------
問題是,如果將記錄插入到一個臨時表時,在vb調用ado去拿記錄時,就不出錯,但沒有記錄。
如果直接用以下的語句:
SELECT *
into #abc
FROM table
ORDER BY Process2.ItemID
再用vb去拿記錄時,就會有記錄出現?這是為什麼??請高手幫忙呀?這個問題急要呀。
SET NOCOUNT OFF