Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1NIEEx74277 for ; Fri, 23 Feb 2001 13:14:14 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from hotmail.com (f195.law12.hotmail.com [64.4.19.195]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1L01Hx89097 for ; Tue, 20 Feb 2001 19:01:17 -0500 (EST) (envelope-from postgres99@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 20 Feb 2001 16:01:14 -0800 Received: from 63.84.236.158 by lw12fd.law12.hotmail.msn.com with HTTP; Wed, 21 Feb 2001 00:01:14 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:01:14 -0500 Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Message-ID: X-OriginalArrivalTime: 21 Feb 2001 00:01:14.0406 (UTC) FILETIME=[68087460:01C09B99] X-Archive-Number: 200102/166 X-Sequence-Number: 1123 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.