Restricting cols with a data view

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

Guest

Hi,

I've always used Database views to restrict columns from the user. Is this
what ADO Dataviews are also meant for? I see how you can filter rows with a
data view, but how about columns? Can this be done with a dataview? Is there
a better mechanism to do this with?

Thanks for any ideas in advance.
Ant
 
Ant,

You can do that in version 2005 with the overloaded function
dataview.totable. In earlier versions you have to do that in a loop.

I hope this helps,

Cor
 
Back
Top