>>>>The click event of my save command button calls a procedure. The procedure updates some values in a cursor. Control then returns to the click event. The commands following the procedure appear to be using the previous cursor values, not the values the procedure updated. How do I tell it to use the updated cursor? The cursor is based on a remote view.
>>>>
>>>>Jeff Rusch
>>>>UW-Madison
>>>
>>>Try to close the cursor, when u call the procedure.
>>
>>I'll give that a try. Thanks!
>>
>>Jeff
>
>requery?

I guess I misstated my problem. At first I thought the problem was occurring due to the procedure running. But I don't think that is the problem. My dataenvironment contains a remote view called tpd_payments_lte.

Towards the end of my click event code I need to know the SUM of one of the fields in tpd_payments_lte. I issue the following code:

SELECT SUM(payment_amount) FROM tpd_payments_lte;
WHERE claim_number = p_claimno INTO ARRAY total_tpd_amount

The problem seems to be that the SELECT statement is using the data from that is current on the server, not the data that is currently in the open cursor total_tpd_amount.

For example, if I go to the data session window while my form is running and browse tpd_payments_lte, it contains data (that hasn't been saved using tableupdate yet). But if I go to the command window and type the SELECT command, I don't get any data.

Jeff