I think your problem is that revdb_movenext is a function and when you call a function from within a script, you have to tell it what to do with the result, you can't just have it all on it's own in a line with no other action.
I have used something like this:
put revdb_movenext(cursorID) into moveOK
if moveOK <> true then beep -- errorYou can also use "get" which puts the result into "it", which can be checked or not, depending on your needs.
get revdb_movenext(cursorID)
Cheers, Sarah [EMAIL PROTECTED] http://www.troz.net/Rev/
On Friday, March 21, 2003, at 08:07 am, Chris Sheffield wrote:
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 _______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
