Within the four different DBs that I have played with, when there is naming
issues of the columns, the DBs have resolved it typically with a "1" or
"A/B" attached to the end of the column name......
(Select * from Customer, Orders)... would result in the customerID to be
recalled twice..... hence two columns, different names..... a 1 & 2
....... or an A & B versions..... one from each table
As far as I'm aware, the DB table names are not available as part of the
dataset/datatable structure....
The DB table used to be available through VB6 and ADODB recordsets.... as
long as it was still connected to the database... but lost that as soon as
the recordset crossed over a process boundry (or so that was our
experience).
HTH....... aloha
"Robert Morris" <ro***********@bellsouth.net> wrote in message
news:08****************************@phx.gbl...
I agree it shouldn't be an issue ... and thanks for your
response.
Here is the problem, I have several middle-tiers and none
that required so much compatibility with existing "stuff"
as this one. I am dealing with stored procedures that may
have multiple table aliases to the same table. When I
return the data to the object layer I need to identify
fields with the same name uniquely, preferably by the
table alias. There was a way, I think, in ADODB to get
the table aliases. I can not seem to find a way to do
this in ADO.NET.
Any help is appreciated greatly,
- Rob
-----Original Message-----
retrieving the data shouldn't be an issue........
Inserts, updates and deletes...... are a different
story....... the SPalmost needs to be a program within itself...... to
deal with FIELDS......and it combines them up into the appropriate SQL
statements..... for thevarious tables
If you provided just a little more info on what your
doing with the join....it would be easier to assist.........
"Rob Morris" <ro***********@bellsouth.net> wrote in
messagenews:05****************************@phx.gbl... Does anyone have a decent resolution to data layer
handling of stored procedures with inner and outer
joins?
.