Received: from hotmail.com (f76.law12.hotmail.com [64.4.19.76]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1L0Gox90436 for ; Tue, 20 Feb 2001 19:16:50 -0500 (EST) (envelope-from postgres99@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 20 Feb 2001 16:16:46 -0800 Received: from 63.84.236.158 by lw12fd.law12.hotmail.msn.com with HTTP; Wed, 21 Feb 2001 00:16:46 GMT X-Originating-IP: [63.84.236.158] From: "Postgres El Mejor" To: pgsql-interfaces@postgresql.org Subject: FOR UPDATE is not allowed in this context Date: Tue, 20 Feb 2001 19:16:46 -0500 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 21 Feb 2001 00:16:46.0823 (UTC) FILETIME=[93CBFF70:01C09B9B] X-Archive-Number: 200102/134 X-Sequence-Number: 1091 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, ------------------------------------------------------------------------- Jhon Orellana Quito - Ecuador South America _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.