Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement