select for update error during precompilation - Mailing list pgsql-interfaces

From Jimmy Román R.
Subject select for update error during precompilation
Date
Msg-id 001601bf208e$cf696920$58010a0a@eljuri.com
Whole thread Raw
List 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:

Previous
From: Nicolas Huillard
Date:
Subject: RE: [INTERFACES] Replication between MS Access and PostgreSQL
Next
From: Martin Crundall
Date:
Subject: Instant ASP from HalcyonSoft: