An updateable view in a live application of mine has stopped working and now I cant figure out how it ever worked in the first place:(

The view (V_PrevWinItem) selects from a table Winitm (winning Items) and another view V_Tickitm

It is supposed to select out all the items that are in Winitm and also in V_tickitm and put them in V_PrevWinItem

It uses the view V_PrevWinItem to do some work on these items then possibly adds a few more items and hopefully writes the lot back to Winitm with a Tablupdate().

My understanding now is that this process should never have worked in the first place because I used a view (V_tickitm) containing uncommitted items in the select. (but it did work)

Now however the V_PrevWinItem is always empty, which I am told is what I should have expected in the first place.

To try and make it work I commited the view V_tickitm but it made no difference.

I would probably be able to fix the routine by copying out the items in V_Tickitm to a temporary table and creating the View based on that table and V_winitm, but the table would not be in the DBC so I could not use it in a view.

And anyway I am getting Fatal Errors whenever I try to create a View programattically!

Sigh:(

Oh well its Friday night and I am fed up. I am going home.

Night All