Information générale
Titre:
How to create an updatable query on self join
Hi.
I have a complex problem(according to me). I have file storing Cheque Information. The transaction of this file contain among other things, the cheque details. A cheque may be presented first time or may by re=presented since it was bounced.
I have a flag to keep track of this. Using another flag I know whether it is returned or cashed. I have to present to the user the cheques returned but not re-deposited. I achieve this by creating an SQL union. The user wants to update these records by saying that they received cash.
I tried to solve the problem by using an SQL update. Then I see that the table is not getting updated.
My problems are
1. I dont know how to create an updatable view of the cursor I create using a SELECT UNION.
2. This table has two other updatable queries opened with table buffering. So how can I directly update this table using an SQL UPDATE.
Is there any other means of solving my problem.
thanks
alex
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