Received: from mailman.eljuri.com ([209.149.224.18])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA90128
	for <pgsql-interfaces@postgresql.org>;
	Wed, 27 Oct 1999 10:20:57 -0400 (EDT)
	(envelope-from jroman@eljuri.com)
Received: from dellnbkjrr.eljuri.com (DELL-NBK-JRR [10.10.1.88]) by
	mailman.eljuri.com with SMTP (Microsoft Exchange Internet Mail
	Service Version 5.5.2448.0)
	id 40PDHTM6; Wed, 27 Oct 1999 09:12:13 -0500
Message-ID: <001601bf208e$cf696920$58010a0a@eljuri.com>
From: "=?iso-8859-1?Q?Jimmy_Rom=E1n_R.?=" <jroman@eljuri.com>
To: <pgsql-interfaces@postgresql.org>
Subject: select for update error during precompilation 
Date: Wed, 27 Oct 1999 09:20:22 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0013_01BF205C.7EE23FE0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

This is a multi-part message in MIME format.

------=_NextPart_000_0013_01BF205C.7EE23FE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 =3D :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 =3D 'abcd' FOR UPDATE;

Thanks in advance for your help,

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

------=_NextPart_000_0013_01BF205C.7EE23FE0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Greetings:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>When precompiling the following =
sentence the=20
precompiler shows the message "FOR UPDATE is not allowed in this=20
context".</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>EXEC SQL SELECT camp_1 INTO :n1 WHERE =
llave =3D=20
:var_llave FOR UPDATE;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>It seems to be a problem with the host =
variables=20
because it precompiles well the following sentence:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2><FONT face=3DArial size=3D2>EXEC SQL =
SELECT=20
</FONT>camp_1 INTO :n1 WHERE llave =3D&nbsp;'abcd' FOR =
UPDATE;</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance for your =
help,</FONT></DIV>
<DIV>&nbsp;</DIV></DIV>
<DIV><FONT face=3DArial=20
size=3D2>----------------------------------------------------------------=
---------------------------------<BR>Jimmy=20
Roman R.<BR>Guayaquil - Ecuador<BR>South =
America</FONT></DIV></BODY></HTML>

------=_NextPart_000_0013_01BF205C.7EE23FE0--