SQL与VB的问题
请教怎么在VB中执行以下语句?????
DECLARE p_num NUMBER;
BEGIN
SELECT rp.next_num
INTO p_num
FROM pm.RC_RS rp
WHERE rp.org_id = 84;
COMMIT;
END;
问题点数：0、回复次数：2Top
1 楼mingxuan3000（铭轩）回复于 2005-06-05 15:01:52 得分 0
顶下Top
2 楼yuanshujian（小袁）回复于 2005-06-05 22:05:38 得分 0
Dim SQL As String
SQL = "DECLARE p_num NUMBER;" & vbCrLf
SQL = SQL & "SELECT rp.next_num" & vbCrLf
SQL = SQL & "Into p_num " & vbCrLf
SQL = SQL & "WHERE rp.org_id = 84;" & vbCrLf
SQL = SQL & "COMMIT;" & vbCrLf
SQL = SQL & "END;"Top
