>I have a table set with optimistic table buffering in the dataenvironment of a form.
>
>I make an update to this table using update-sql and I don't commit the changes.
>
>Next I do a query on that table using select-sql and write the results in a cursor. I don't see the changes I previously made since I didn't commit the changes.
>
>Is there any way I can query the table and see the changes I made without committing?
Not with SQL.
You can build a cursor with a SCAN loop though.
Erik Moore
Clientelligence