FieldByName when the same field exists.

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by sky Sun, 08 Oct 2006 06:27

#390

Author: 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

Re: FieldByName when the same field exists.

#391

Author: sky
Date: Mon, 09 Oct 2006 03:47

3 lines
1075 bytes

I got it!

add the table name when using the repeated field just like 'T1.F1'

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads