I think that the FOR UPDATE clausel is only to be used in cursors. Did you
use it in a cursor?


Am 28.06.2004 16:43 Uhr schrieb "andreas14051980" unter <a.roos@...>:

> Hello.
>
> I am using the following sql-statement:
>
> select * from commandqueue where state=0 for update
>
> The table has two columns: id (integer) and state (integer)
>
>
> I get the Exception
>
>
> The resultset is not in a row, use next?
>
> Can anybody tell me what that means?
>
> Andreas
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=12988e9qg/M=295196.4901138.6071305.3001176/D=grou
> ps/S=1705006764:HM/EXP=1088520909/A=2128215/R=0/SIG=10se96mf6/*http://companio
> n.yahoo.com>
>
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> * http://groups.yahoo.com/group/Firebird-Java/
> *
> * To unsubscribe from this group, send an email to:
> * Firebird-Java-unsubscribe@yahoogroups.com
> <mailto:Firebird-Java-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> *
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>

--
_ _ _
)) _ __ ___ ))_ ___ __ __))
((_)((_( (| ((_( ((`( ((_( (| ((_(
_))
http://www.news.cornell.edu/releases/July97/guitar.ltb.html



[Non-text portions of this message have been removed]