HELP!!!!!!!!!!!!!!!!!! 
Author Message
 HELP!!!!!!!!!!!!!!!!!!
Hi,

VB6 - ADO - SQL Server 7

I have a problem, if I join multiple tables in a query which happen to have
the
same field name such as [Unit Price], when ADO returns me the recordset it
shows only the field name. This is really screwing up my reports, I have to
provide them with the full field definition e.g [Order Detail].[Unit Price].
Is there anyway of returning this?

Thanks for you help in advance




Tue, 23 Apr 2002 03:00:00 GMT
 HELP!!!!!!!!!!!!!!!!!!

Try using

Select table1.name as name1, table2.name as name2 from table1, table2

then refer to the fields as

rs!name1 and rs!name2

Paul


Quote:
> Hi,

> VB6 - ADO - SQL Server 7

> I have a problem, if I join multiple tables in a query which happen to
have
> the
> same field name such as [Unit Price], when ADO returns me the recordset it
> shows only the field name. This is really screwing up my reports, I have
to
> provide them with the full field definition e.g [Order Detail].[Unit
Price].
> Is there anyway of returning this?

> Thanks for you help in advance





Tue, 23 Apr 2002 03:00:00 GMT
 HELP!!!!!!!!!!!!!!!!!!
No there isn't a think.
you must provide the tablename first.

I must use it on every SQL string you use.

Noam

Quote:

>Hi,

>VB6 - ADO - SQL Server 7

>I have a problem, if I join multiple tables in a query which happen to have
>the
>same field name such as [Unit Price], when ADO returns me the recordset it
>shows only the field name. This is really screwing up my reports, I have to
>provide them with the full field definition e.g [Order Detail].[Unit
Price].
>Is there anyway of returning this?

>Thanks for you help in advance





Wed, 24 Apr 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. help,help,help,help,help,help,help,help,help,help,help,help,help,

2. Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,

3. help help help help help help help help help

4. SQL To ORACLE Help Help Help Help Help

5. query:HELP! HELP HELP HELP HELP

6. HELP HELP HELP HELP

7. HELP HELP HELP HELP!

8. Help help help help

9. HELP HELP HELP !!!

10. HELP HELP HELP!!!!

11. help, help, HELP!

12. HELP HELP HELP!


 
Powered by phpBB® Forum Software