Article View: borland.public.interbase.sql
Article #790Re: Query CDS
From: Serra
Date: Wed, 18 Jul 2007 20:20
Date: Wed, 18 Jul 2007 20:20
17 lines
1481 bytes
1481 bytes
Thank you Bill, I want to get all part numbers in orderdetail table's current record suppose something like this SELECT * FROM PARTS WHERE PARTNO IN ( SELECT PARTNAME FROM CDS(which is orderdetail) WHERE RECNUM=133) * ( the data in CDS( orderdetail) is not in database ) * > Do you want just the part > record for the current order detail record, that is, the one order > detail record that the CDS cursor is on or do you want all of the part > records for all of the order detail records in the order detail CDS? > > -- > Bill Todd (TeamB)
Technical Details
Message-ID:
<469e7611@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-mailReferences:
<469bdbf9$1@newsgroups.borland.com> <469bf567$1@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: "Serra" <no@no.com> Newsgroups: borland.public.interbase.sql References: <469bdbf9$1@newsgroups.borland.com> <469bf567$1@newsgroups.borland.com> Subject: Re: Query CDS Date: Wed, 18 Jul 2007 23:20:34 +0300 Lines: 19 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 88.241.178.149 Message-ID: <469e7611@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1184790033 88.241.178.149 (18 Jul 2007 13:20:33 -0700) 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