revdb_movenext

Sarah sarahr at genesearch.com.au
Thu Mar 20 18:52:27 EST 2003


Chris,

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   -- error

You 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
sarahr at genesearch.com.au
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
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>






More information about the use-livecode mailing list