>
>Hi,
>by "behaving strangely" I mean :
>
>select * from storedProc1. result (2 rows) = 1 , 9
>select * from storedProc1. result (2 rows) = 1 , 9
>select * from storedProc1. result (2 rows) = 1 , 9
>select * from view1. result immaterial (but correct)
>select * from storedProc1. result = 0 , 9
>
>Just these statements are executed. StoredProc1 does no updating,
>but does select from view1. View1 uses the table with the trigger.
>

If you select * from view1 multiple times in a row do you get the same
results?


What about if you select * from view1 after the last select above (result =
0 , 9)?



Bill