Skip site navigation (1) Skip section navigation (2)

select for update error during precompilation

From: Jimmy Román R(dot) <jroman(at)eljuri(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: select for update error during precompilation
Date: 1999-10-27 15:20:22
Message-ID: 001601bf208e$cf696920$58010a0a@eljuri.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Greetings:

When precompiling the following sentence the precompiler shows the message "FOR UPDATE is not allowed in this context".

EXEC SQL SELECT camp_1 INTO :n1 WHERE llave = :var_llave FOR UPDATE;

It seems to be a problem with the host variables because it precompiles well the following sentence:

EXEC SQL SELECT camp_1 INTO :n1 WHERE llave = 'abcd' FOR UPDATE;

Thanks in advance for your help,

-------------------------------------------------------------------------------------------------
Jimmy Roman R.
Guayaquil - Ecuador
South America

pgsql-interfaces by date

Next:From: Martin CrundallDate: 1999-10-27 22:40:46
Subject: Instant ASP from HalcyonSoft:
Previous:From: Nicolas HuillardDate: 1999-10-27 13:41:25
Subject: RE: [INTERFACES] Replication between MS Access and PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group