Oracle - VB5 - Why don't open a Recordset like a adOpenStatic with ADO?

Why don't open a Recordset like an adOpenStatic, adOpenKeyset or adOpenDynamic with ADO?

This is the code:

    conn = "DSN=trans;UID=trans;PWD=trans;"     

    Set cx = New ADODB.Connection
    cx.ConnectionString = conn     

    cx.Open     

    SQL = "select * from usuarios"     

    Set comando = New ADODB.Command

    comando.ActiveConnection = cx
    comando.CommandText = SQL
    comando.CommandType = adCmdText
    

    Set rs = New ADODB.Recordset
    rs.CursorType = adOpenStatic
    rs.CursorLocation = adUseClient     

    rs.Open , conn, adOpenStatic     

    Set rs = comando.Execute     

Thanks

Carlos Marcelo Santos
cms_at_sminter.com.ar Received on Tue May 19 1998 - 12:06:34 CDT