Stored Procedure如下:
CREATE PROCEDURE sp_M01USearch
@Dlrnum as varchar(10),
@Kind as varchar(2)
AS
if ltrim(rtrim(@dlrnum))='' and ltrim(rtrim(@kind))=''
select * from XXX
else
select * from cttfg where XX=@kind or XXX=@dlrnum
在VB中call Stored Procedure:
l_rsFind.Open "execute sp_M01USearch '" & Trim(txtCDlrNum.Text) & "','" & Trim(txtCKind.Text) & "'", cnn, adOpenKeyset, adLockReadOnly, adCmdText
問:
1,為什么我debug.print l_rsFind.cursorType時得出的結果并非為我設定的adOpenKeyset呢??
2,為什么l_rsFind.RecordCount的值為-1 ??
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(1) 人氣()