Extra coloumns

  • Thread starter Thread starter Angelina
  • Start date Start date
A

Angelina

hi,

i have written a query n the oledbadapter and i keep
getting rows that should not be displayed in my datagrid.
the query is as follows:

SELECT Caravan_Inv.Caravan_Inv_No,
Caravan_Inv.Caravan_Model, Caravan_Inv.Length,
Caravan_details.Beds, Caravan_details.[Cost/day],
Caravan_details.Caravan_Model AS Expr1,
Caravan_details.Length AS Expr2 FROM Caravan_Inv INNER
JOIN Caravan_details ON Caravan_Inv.Caravan_Model =
Caravan_details.Caravan_Model

the additional coloumns are the Expr1 and Expr2. Even
when i delete them from my query, they still seem to show
up in my result.
Why do they appear? I am using the query builder of the
OLEDBAdapter.

thx
 
The Expr columns are the result of mistakes made in the Query Builder. See
my earlier post. I suspect the generated source code is being left in your
program... think stored procedures if you can.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top