Re: Query CDS

Article View: borland.public.interbase.sql

Article #791

Back to borland.public.interbase.sql Previous Next

#791

From: Bill Todd
Date: Wed, 18 Jul 2007 21:42

15 lines
1609 bytes

SELECT * FROM PARTS WHERE PARTNO IN ( SELECT PARTNAME
FROM CDS WHERE RECNUM=133)

This query does not make sense because you are asking for the PARTS
records whose PARTNO appears in a list of PARTNAMEs returned by the
subquery. I assume that a PARTNO will never appear in the PARTNAME
field. I think what you want is:

SELECT * FROM PARTS WHERE PARTNO = :PARTNO

I assume the OrderDetail record contains the PARTNO so all you have to
do is assign the PARTNO from the OrderDetail record to the :PARTNO
parameter in the SELECT statement and open the PARTS CDS.
-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <469e893d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <469bdbf9$1@newsgroups.borland.com> <469bf567$1@newsgroups.borland.com> <469e7611@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,76c2c8ad3cbcc7f0
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Query CDS
Newsgroups: borland.public.interbase.sql
References: <469bdbf9$1@newsgroups.borland.com> <469bf567$1@newsgroups.borland.com> <469e7611@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: <469e893d$1@newsgroups.borland.com>
Date: 18 Jul 2007 14:42:21 -0700
X-Trace: newsgroups.borland.com 1184794941 216.207.211.19 (18 Jul 2007 14:42:21 -0700)
Lines: 15
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
X-Original-Bytes: 1452

Reply to Parent Message