AnsweredAssumed Answered

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

Question asked by williamho on Sep 26, 2010
Latest reply on Sep 27, 2010 by 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

Outcomes