Dataset column disappear

[Guest]

HI,

I am Roby Eisenbraun Martins. I am a VC++, VB and NET developer.
I am having a very strange situation here with NET 2002.
I got a dataview been created from a dataset with two SPs.
DataView.Table = DataSet.Q_SupportCallSummary
This part of the code is executed several times and it works fine but
then, running one another time, the application crashes in this code line
with this error message "column "Overview" doesn't belong to table".
There is a Overview column in the Q_SupportCallSummary SP and if you open
the dataset design you can see the "Overview" column there.
How can this be possible?

Thank you,
Roby Eisenbraun Martins

 

[Guest]

You say two SPs. Do you mean there are two DataTables filled from two stored
procedures?

If so, it could be that the call is being matched to the wrong DataTable. To
avoid this, you should use table mappings. I would also consider putting both
selects in a single procedure or separating out the two DataTables when you
get data to avoid the ambiguity.

If none of the above, I am out of options without more information.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************