Hi Leland

Liam,

If you have time to spend try this:

1. In the database create a table with 3 columns: an Id, a name, and a column called "balance" (numeric 10,2).

2. Then in VFP create a remote view with all those fields and a calculated column: balance*2 as newbalance. That view has to have a filter. Use a filter for the ID field, like id=?idsel

3. Input some data in that table (3 rows are enough)

4. Open the remote view with NODATA clause

5. set the idsel variable to a value contained in the table. Then execute the REQUERY().

So far I allways got "view definition has been changed"

In fact, that error occurs every time that view would return a valid result (at least one row) after being empty (because of the last result).

Regards,

Dany