Filtering uncommited data ?

  • Thread starter Thread starter PL
  • Start date Start date
P

PL

If I do a select query with the hint WITH (NOLOCK) are uncommited
reads marked somewhere in the dataset/datatable/datarow so I can filter them
out ?

I havent been able to find a flag to use for this.

Thank you
PL.
 
Miha Markic said:
Hi,

No, they are not.
Click to expand...


Ok, thank you.

Seems this would be a good feature to add.

If the dataset came from a database that really didnt have transactional
support the
flag would just be false.

PL.
 
The Data Set is totally decoupled from the Datasource and as such, it has no
way to know anything about where its data came from. Since it's disconnected
and meant to operate outside of the context of a connection - this would be
pretty hard to implement. I can definitely see your point though - that
when the dataset is getting filled you could have a flag for this - but
since you're disconnected there'd be no way to know if any of the rows were
commiteed without heading back to the db.
 
Back
Top