Post reply

Retrieving updated rowset

  • December 8, 2003 at 6:28 pm

    #83507

    Hi! I'd like to ask if there is an SQL update statement or special function that will enable me to update a record and at the same time retrieve the updated record without issuing a select statement after the update.

  • December 11, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • December 11, 2003 at 8:41 am

    #485734

    Don't think this is possible in SQL.

    Can be done in ADO (and the like). If you have an updateable RecordSet object, you can change the values of a row in the object and apply them. (Don't know the exact syntax by hard...)

    In the object, you will see the 'new' values.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply