Re: Select from variable

Article View: borland.public.interbase.sql

Article #972

Back to borland.public.interbase.sql Previous Next

#972

From: Bill Todd
Date: Mon, 02 Apr 2007 19:33

13 lines
1220 bytes

aleplgr wrote:

> SELECT MAX(GENE) FROM TEMPORALPRUEBA1 WHERE 
>  CLIENTID = MINCLIENTID  INTO :IDMAX;

SELECT MAX(GENE) FROM TEMPORALPRUEBA1 WHERE 
 CLIENTID = :MINCLIENTID  INTO :IDMAX;

When you use a variable in an SQL statement you must prepend a colon to
the variable name.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <46114c8c$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <46112987$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,9d569d1fdba243ad
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Select from variable
Newsgroups: borland.public.interbase.sql
References:  <46112987$1@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <46114c8c$1@newsgroups.borland.com>
Date: 2 Apr 2007 11:33:48 -0800
X-Trace: newsgroups.borland.com 1175538828 216.207.211.19 (2 Apr 2007 11:33:48 -0800)
Lines: 13
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message