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