Derek,
Take a look at if mskb #
Q138094 How to Create Updatable Views by Using SQL Passthrough> and faq #8153
How to make SQL Pass-Through cursor updatable>I've tried that already, tableupdate() returns .T. so I've been unable to trace any error.
>
>I'm executing an SQL stored procedure to return 1 record, i.e. the selected user record that I'd like to edit. There are three records in my user table and although the SQL procedure will select any other those, it will ONLY update the very first record; strange.........?
>
>I've even played around with the record ID's and it still only allows updates on the very first record in ANY of my SQL tables.
>
>Would it have anything to do with the row/record buffering settings from within VFP itself?
>
--sb--