Helen, is it advisable to use views instead of the selectable SP (select *
from StoredProcedure)? if data changes in a view, are changes automatically
fetched from the server to synchronize dataset?

At 2003-11-27 15:06, you wrote:

>This of course can only be used to *represent* a M/D relationship in your
>application, since it is not realising a M/D relationship that exists in
>the database...as soon as you change something in either the
>"pseudo-master" or the "pseudo-detail" the "other side" of the relationship
>will be broken. You'll be able to define customSQL for editing purposes
>but the datasets will then both be out of date. SPs aren't views! You
>will have run both SPs again after committing, to get a fresh view.

--/ Gediminas /--
The Truth Is Out There