Purging Dataset

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

Guest

I have a DataSet that contains 6 tables. When I write to the first table, all goes well, and my database gets updated. When I start to reference the second table, I get an error message that a colomn from the send table is not part of the first table

Key portions of code follow

PipeData1.Clear(
OleQAOrderDbDataAdapter.Fill(PipeData1
drCurrent = tblWorkOrder.NewRo
drCurrent("WorkOrder") = Text3.Tex



drCurrent("QASpec") = Combo3.Tex
tblWorkOrder.Rows.Add(drCurrent
OleQAOrderDbDataAdapter.Update(PipeData1

PipeData1.Clear(
OleQALoadsDbDataAdapter.Fill(PipeData1
drCurrent("WorkOrder") = Text3.Tex
drCurrent("TrailerID") = Text16.Text (fails on this line. Note tat "WorkOrder" is a valid column from OleQAOrderDbDataAdapter

Any suggestions

(Thanks in advance

Leon Kemp
 
Hi Leon,
PipeData1.Clear()
OleQAOrderDbDataAdapter.Fill(PipeData1)
Click to expand...

We cannot see this, but I get the idea PipeData1 is your dataset and not
your table.
So this could be
\\\
PipeData1.Tables("mytable1").Clear()
OleQAOrderDbDataAdapter.Fill(PipeData1, "Mytable1")
///
But just a guess?

Cor
 
Cor

You were correct in your assumption, PipeData is the Dataset. I will give this a shot

Thank

Leo
 
Back
Top