Only for clearance: the message of the exception is "The resultset is not in
a row, use next?" right?

Another question is why are you using "FOR UPDATE" ? Can you try it without
the FOR UPDATE clausel? I only use FOR UPDATE in a cursor when I want to
UPDATE <table> SET <column>=<value> WHERE CURRENT OF <cursorname>
In which context are you using the FOR UPDATE?



Am 28.06.2004 19:06 Uhr schrieb "Francisco Souza" unter
<franciscosouza2002@...>:

> SQL Language Extension: WITH LOCK clause in the SELECT statement
>
> Syntax
> ========
>
> SELECT ... FROM <sometable> [WHERE ...] [FOR UPDATE [OF ...]] WITH LOCK;
>
> The WITH LOCK clause lets you lock the selected rows so that
> other users cannot lock or update the rows until you end your
> transaction. You can specify this clause only in a top-level
> SELECT statement (not in subqueries). This clause can be used
> in DSQL and PSQL.
>
> Restrictions:
> - You cannot specify this clause with the following other constructs:
> the DISTINCT operator, group_by_clause, or aggregate functions.
> - from_clause of SELECT statement must specify single database table
> (views and external tables are not allowed)
>
> Author:
> Nickolay Samofatov <skidder@...>
>
> RnJhbmNpc2NvIEFudG9uaW8gVmVpcmEgU291emE=
> -----Mensagem original-----
> De: Burghard W.V. Britzke [mailto:bubi@...-berlin.de]
> Enviada em: segunda-feira, 28 de junho de 2004 13:05
> Para: Firebird-Java@yahoogroups.com
> Assunto: AW: [Firebird-Java] What does that exception mean
>
>
> 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=gr
> ou
>>
> ps/S=1705006764:HM/EXP=1088520909/A=2128215/R=0/SIG=10se96mf6/*http://compan
> io
>> 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]
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
>
> 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
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.708 / Virus Database: 464 - Release Date: 18/06/2004
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>

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