Does Dataset.Tbl.Clear() clear all tables or One?

Does a clear command (ie: DataSet11.TableName.Clear() ) clear just the named
table or all the tables in the set? It appears to be all? How can I clear,
in order to fill, a specific table in a dataset of many tables?

Thanks

Paul
Wed Oct 29 07:43:36 CST 2003

On Tue, 28 Oct 2003 17:44:59 -0800, "Daryll Shatz" <dshatz@hotmail.com> wrote:

¤ Does a clear command (ie: DataSet11.TableName.Clear() ) clear just the named
¤ table or all the tables in the set? It appears to be all? How can I clear,
¤ in order to fill, a specific table in a dataset of many tables?
¤

Try:

MyDataSet.Tables("MyDataTableName").Clear()


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Daryll
Wed Oct 29 11:32:02 CST 2003

Thanks, Paul. I tried your syntax too and it still clears all the tables in
the dataset. I guess my question is:

What is it intended to do??? Have you used the Clear method and only had
it clear the named table? If so, this suggests an error in my logic/code
somewhere.

Has anyone else had this problem?



"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:5ugvpvslvmem32nc6n4mrrufi107mmi423@4ax.com...
> On Tue, 28 Oct 2003 17:44:59 -0800, "Daryll Shatz" <dshatz@hotmail.com>
wrote:
>
> ¤ Does a clear command (ie: DataSet11.TableName.Clear() ) clear just the
named
> ¤ table or all the tables in the set? It appears to be all? How can I
clear,
> ¤ in order to fill, a specific table in a dataset of many tables?
> ¤
>
> Try:
>
> MyDataSet.Tables("MyDataTableName").Clear()
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Daryll
Wed Oct 29 12:41:02 CST 2003

I discovered the error in my logic.

I had a listbox bound to a dataview. When I added a record to the dataview,
it triggered the listbox selected events. This somehow caused the other
tables to be cleared. I still need to find this connection but the problem
is mine not VB.

Please ignore this thread. Thanks


"Daryll Shatz" <dshatz@hotmail.com> wrote in message
news:eSTYTKknDHA.2964@tk2msftngp13.phx.gbl...
> Thanks, Paul. I tried your syntax too and it still clears all the tables
in
> the dataset. I guess my question is:
>
> What is it intended to do??? Have you used the Clear method and only had
> it clear the named table? If so, this suggests an error in my logic/code
> somewhere.
>
> Has anyone else had this problem?
>
>
>
> "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
> news:5ugvpvslvmem32nc6n4mrrufi107mmi423@4ax.com...
> > On Tue, 28 Oct 2003 17:44:59 -0800, "Daryll Shatz" <dshatz@hotmail.com>
> wrote:
> >
> > ¤ Does a clear command (ie: DataSet11.TableName.Clear() ) clear just the
> named
> > ¤ table or all the tables in the set? It appears to be all? How can I
> clear,
> > ¤ in order to fill, a specific table in a dataset of many tables?
> > ¤
> >
> > Try:
> >
> > MyDataSet.Tables("MyDataTableName").Clear()
> >
> >
> > Paul ~~~ pclement@ameritech.net
> > Microsoft MVP (Visual Basic)
>
>