1 Reply Latest reply on Sep 27, 2010 6:11 PM by williamho

    cannot get any value from filemaker pro 's field database by using vb6 or realbasic tools

    williamho

      Title

      cannot get any value from filemaker pro 's field database by using vb6 or realbasic tools

      Your post

      hi all professional,

                      I 'm new for filemaker pro  and I trying to build an application by using vb6 and store/retrieve all the data from filemaker pro database.The problem is I can't retrieve any value from the filemaker 's pro database fields. Can someone help me on this ? besides that , for you all information, I have installed the both filemakerpro & filemaker pro server advanced in my pc ( trial version).

      The codes for vb6 is below.

      Dim cn As ADODB.Connection
      Dim rs As ADODB.Recordset
      Dim counter As Integer
         
          Set cn = New ADODB.Connection
          Set rs = New ADODB.Recordset

        cn.Open "DSN=FMtest;Uid=Admin;Pwd=;"
       cn.CursorLocation = adUseClient

          rs.Open "Select ID from test", cn, adOpenKeyset, adLockOptimistic
         
          If rs.EOF = False Then
        
              Do While rs.EOF = False
        
            
                  MsgBox rs("ID").Value
                 
                  rs.MoveNext
              Loop
          End If
         
        
        
      rs.Close
      cn.Close

      thanks in advance

      regards

      william