>My data-handling objects use VFP cursors and TableUpdate() to save records - one at a time. If the record is new - I want to retrieve the identity value for the new record. I have been using @@identity but it is useless if you have cascading-insert triggers on the table you insert into.
There are some ways around that. They were devised for 7.0 before we had scope identity but still work in 2000. Here is an article that describes the two techniques.
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9736BOb