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