Extra columns in my datatables when the dataadapter wizard is used!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have created a dataset using a single dataadapter. I use the same dataadapter to run various SQL queries to create numerous datatables. All the datatables are added to the same dataset. What i have noticed is that when i rightclick on the dataset that is created and select 'view schema' some of the datatables containadditional columns. These column are expr1, expr2, expr3 etc. I have no idea what these are? Does anyone know what these additional coloumns are used for? I tried to delete them but then my application gets errors!!
 
Hi,

. said:
Hi,

I have created a dataset using a single dataadapter. I use the same
Click to expand...
dataadapter to run various SQL queries to create numerous datatables. All
the datatables are added to the same dataset. What i have noticed is that
when i rightclick on the dataset that is created and select 'view schema'
some of the datatables containadditional columns. These column are expr1,
expr2, expr3 etc. I have no idea what these are? Does anyone know what these
additional coloumns are used for? I tried to delete them but then my
application gets errors!!

This columns are not "native" table columns, maybe thay are calculated
values or something else.
What does your select look like?
 
here is what my select statment looks like for one of my tables. This table contains 3 attional columns!!! .....
Expr1
Expr2
Expr3

I do not have any calculted fields in the sql statment that is why i do not know why these additional columns are created.
All the additional columns are marked as keys!!!

SELECT a.BookingNo,
a.Caravan_Inv_No,
b.Caravan_Model,
b.Length,
c.Cost
FROM Caravan_Booking a,
Caravan_Inv b,
Caravan_Details c
WHERE a.Caravan_Inv_No = b.Caravan_Inv_No
AND b.Caravan_Model = c.Caravan_Model
 
Back
Top