Why don't open a Recordset like an adOpenStatic, adOpenKeyset or

From: pert <pert_at_startel.com.ar>
Date: 19 May 1998 18:48:11 GMT
Message-ID: <01bd8356$906360e0$6003010a_at_ALTOR-17.miniphone.com.ar>

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

I'm working with VB5 over Windows NT 4.0 and Oracle 8 over Unix OSF1.

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 - 20:48:11 CEST