logo       
Google Custom Search
    AddThis Social Bookmark Button

vb6 inquiry: msg#00088

Subject: vb6 inquiry
All,

I am working off of the vb6 sample given in the psqlODBC doc that accompanies the odbc driver.  My issue is, when I am displaying the rs.Cursortype, it is reading 3, however this is not what was requested.  Shouldn't this be 2?

Thank You,
Joseph Armbruster

    Dim cn As New adodb.Connection
    Dim rs As New adodb.Recordset

    cn.Open "DSN=test_post;UID=postgres;PWD=acupostgres;Database=vbtest"

    rs.CursorType = adOpenDynamic
    rs.LockType = adLockOptimistic
    rs.CursorLocation = adUseServer
    rs.Open "SELECT id, data FROM vbtest", cn, adOpenDynamic, adLockOptimistic

    MsgBox "AdoEnums.CursorType.DYNAMIC = " & adodb.CursorTypeEnum.adOpenDynamic
    MsgBox "rs.CursorType = " & rs.CursorType & vbCrLf & "rs.CursorLocation = " & rs.CursorLocation

    While Not rs.EOF
        Debug.Print rs!id & ": " & rs!Data
        rs.MoveNext
    Wend

    rs.AddNew
    rs!id = 76
    rs!Data = "" random data"
   
    rs.Update

    cn.Execute "INSERT INTO vbtest (id, data) VALUES (23, 'Some random data');"
    rs.Update


    If rs.State <> adStateClosed Then rs.Close
    Set rs = Nothing
    If cn.State <> adStateClosed Then cn.Close
      Set cn = Nothing

Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>