FieldByName when the same field exists.

Article View: borland.public.cppbuilder.database.ado

Article #390

Back to borland.public.cppbuilder.database.ado Previous Next

#390

From: sky
Date: Sun, 08 Oct 2006 06:27

15 lines
1287 bytes

Hi all

2 Tables: T1(Fields: F1, F2, F3, F4, F5), T2(Fields: F1, F2, F6, F7)
I get a dataset with the sql statement:
select * from T1 LEFT OUTER JOIN T2 ON(T1.F1 = T2.F1 and T1.F2 = T2.F2);
because of the repeated fields F1 and F2
a error occured when I get the value of F1/F2 by using FieldByName() or 
FieldValues[];
Error Message: 'MyADOQuery: Field 'F1' not found'

Any hint?

TIA

sky

Technical Details

Message-ID: <45289a2a@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,3a66196dd6a40a47,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "sky" <akeehuang@163.com>
From: "sky" <akeehuang@163.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: FieldByName when the same field exists.
Date: Sun, 8 Oct 2006 14:27:01 +0800
Lines: 17
Organization: ck
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 125.77.226.171
Message-ID: <45289a2a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1160288810 125.77.226.171 (7 Oct 2006 23:26:50 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!solnet.ch!solnet.ch!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail