|Subject||Re: [ib-support] Again on the updatable views with triggers|
> > record(s) but rather how many rows of the view were operated upon duringthe
> > update (or delete for that matter). With insert it is always just one.Yes, of course. That's easy, how ever many records were selected. In the
> What for insert...select.
case where you are doing an insert without a select it is just a singleton
I've not gotten to where I like to think of RowsAffected as RowsWalked. It's
really the only thing that makes sense to me and it is consistent whether
you are using a table or a view. And, when using tables directly,
RowsAffected is the RowsWalked. And when using views, it is impossible and
in my opinion senseless to try and report how its operations were physically
implemented. Whatever views do in triggers should be considered internal
protected details. What the client needs to know is simply, did you walk any
records and if so, how many.
CPS - Mesa AZ