revdb_movenext

Chris Sheffield cm_sheffield at yahoo.com
Thu Mar 20 17:07:01 EST 2003


I'm trying to use this function but Rev keeps giving
me a "can't find handler" error and refers to this
function.  Here's my code:

on mouseUp
  global dbID
  global cursorID

  if dbID <> empty then
    if cursorID <> empty then
      put revdb_closecursor(cursorID) into cursorID
    end if

    put revdb_query(dbID, field "query") into cursorID
    if cursorID is not an integer then
      answer "An error occurred: " & cursorID
      exit to top
    else
      answer revdb_columnbyname(cursorID, "idNum") &&
revdb_columnbyname(cursorID, "text")
      answer revdb_columnnames(cursorID)
      answer "Current record is " &
revdb_currentrecord(cursorID)
      revdb_movenext(cursorID)
      answer revdb_columnbyname(cursorID, "idNum") &&
revdb_columnbyname(cursorID, "text")
      answer revdb_columnnames(cursorID)

    end if

  end if

end mouseUp

I'm simply clicking a button after entering a basic
SELECT query into field "query".  The query seems to
execute just fine.  I don't get the error until I try
to move to the next record.  There are two records in
my database.  I'm using Valentina.  I'm simply doing a
quick test to see if I can successfully navigate
through a recordset that has been returned from a
query.

If anyone can help, please help me.  :-)

Chris Sheffield
Read Naturally


__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com



More information about the use-livecode mailing list