Database Programming, HELP!!!!!!!!!!!!!!!!!!

HELP!!!!!!!!!!!!!!!!!!

Author	Message
D ROCKET #1 / 3	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

Paul Spence #2 / 3	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

Noam cassi #3 / 3	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

Page 1 of 1

[ 3 post ]