Because the server compiles each stored procedure when you create it, you receive any server syntax errors at create time. When you execute the stored procedure, the server executes the compiled SQL statements sequentially (as in a Visual FoxPro program) and Visual FoxPro fetches each result set from each SQL statement within the stored procedure separately, in the order executed.

Result sets and errors are returned in the order received, and processing stops if an error is encountered. For example, if a run-time error occurs when the server executes the third statement in a four-statement stored procedure, you receive the first two result sets and then receive the error that occurred upon processing the third result set. Processing stops after the error is returned; the fourth result set is not retrieved. You can use the AERROR(В ) function to obtain information about the most recent error.

Note:
You can execute stored procedures on a remote server from Visual FoxPro only by using Visual FoxPro SQL pass-through functions. Views don't support stored procedures on a remote server, because each view contains an explicit SQL SELECT statement in its SQL definition.