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