>I am trying to write a stored procedure on SQL Server 6.5 that will be called from VFP 5 using SQLExec(). The procedure finds a value that I am looking for, puts it into a variable, updates the table to make that value unavailable to other users (marked as assigned), and returns the value to a VFP cursor.
Are you getting a result cursor at all? Is the cursor empty?
Remember that you can return multiple result sets from a stored procedure. You might get the
expected result and it shows up in another work area.
+++ Rick ---