How can you use the LAST_INSERT_ID() MySQL function after inserting a new record in a VFP remoter view.

I have tried many permutations and the best I end up with always returns a value of zero if it doesn't error out.