REALBasic和MySQL

Question

Dim db as MySQLCommunityServer
  db  =New MySQLCommunityServer
  db.host="127.0.0.1"
  db.port=3306
  db.databaseName="requesterdb"
  db.userName="root"
  db.Password=""

  Dim divisionID As String
  Dim supervisorName As String
  Dim lsupervisorTotal As Integer

  If db.Connect then


    dim r as RecordSet
    r=db.SQLSelect("select COUNT(*) As supervisorTotal FROM supervisorTable WHERE supervisorName='" + SupervisorTextField.Text.Trim + "'")

    if r<>nil and r.RecordCount>0 then
      while not r.EOF
        lsupervisorTotal     = r.IdxField(0) // Line with Error
        If lsupervisorTotal > 0 Then
          ' Check User Database and Insert If Needed
        End If

        r.MoveNext
      wend
    end if


  else
    MsgBox "Connection failed!"
  end if

  db.Close

这条消息说：“有几个项目具有此名称，但不清楚调用引用的是lSupervisorTotal = r.IdxField(0)”。

上面是整个方法，我不知道这个错误在说什么。

Answer 1

它应该是r.IdxField(0).integervalue。如果是字符串，则为r.IdxField(0).stringvalue，日期为.datevalue，依此类推。

有关更多信息，请参阅http://docs.realsoftware.com/index.php/RecordSet.IdxField的在线文档