Re: Select from variable

Article View: borland.public.interbase.sql

Article #976

Back to borland.public.interbase.sql Previous Next

#976

From: Frederic Gelinas
Date: Tue, 03 Apr 2007 14:48

6 lines
905 bytes

Here is how I do it in a single statement with IB 7.5.

SELECT MAX(GENE) FROM TEMPORALPRUEBA1 
order by ClientID desc, Gene desc
rows 1 
INTO :IDMAX

Technical Details

Message-ID: <46125b3b@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.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: "Frederic Gelinas" <frederic.gelinas@jebcointernational.com>
Subject: Re: Select from variable
Newsgroups: borland.public.interbase.sql
References:  <46112987$1@newsgroups.borland.com>
User-Agent: XanaNews/1.17.2.7
NNTP-Posting-Host: 74.13.145.58
Message-ID: <46125b3b@newsgroups.borland.com>
Date: 3 Apr 2007 06:48:43 -0800
X-Trace: newsgroups.borland.com 1175608123 74.13.145.58 (3 Apr 2007 06:48:43 -0800)
Lines: 7
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.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