Hey! I need to open a table and modify the records without modifying the original table values and then return the modified version to the client app.

In DB2 there are a number of ways to do this, in SQL there are at least a few. All I need in pervasive is one.

So how about opening a cursor for Update, updating the records and then... and then...umm...

So first, How do you return records that exist within a cursor to the client app (let's presume we've got a valid RETURNS phrase).

Then, how do you be sure that the Records inside the Cursor aren't the underlying table records in the database when you modify them?

Thanks if you know and tell.

Kimball

What exactly are you trying to do?

Are you writing a service that reads from the DB on behalf of the client? Why can't you just change the data in your prog before passing back to the client?

I'm nor sure what you need or why you need it.

Are you talking about inside a stored procedure in Pervasive? If so i would use a working table to insert records into, update, and then select. I think that's the only way you can do this.