How are "Stored Procedures" in a VFP Database processed when the
Database resides on the Server machine?

I've been successful in writing Stored Procedure and getting them to work, but
we will soon be going to a client server solution and we were wondering
exactly how and where the Stored Procedures are processed.

For example, If a Database has a Stored Procedure that generates a unique
incremental key for a field in one of it's table, and this Procedure is
called by the "Default Value" on a field of the table, where is the
processing done? On the Server or the Client?

The Store Procedure code may look like this;
PROCEDURE genkey
RETURN SYS(2015)

When you are in the development mode of VFP or if you are running a VFP
application, and you append a record, the "Genkey" procedure in that
Database's Stored Procedures will be called and automatically generates
a unique value for the desired field.

This is understandable because you are in a VFP environment and can
therefore process any VFP code.

However, this will also work if you are using another program like Visual
Basic or Access, ect... and connect to the VFP Database in question through
an ODBC driver and add a record to the VFP table. Then, where is the processing
taking place? There isn't a VFP EXE running anywhere and VB wouldn't
understand VFP code.

So exactly where does the processing take place? How does the VFP
Database container process it's Stored Procedures?

Where can I look for more information on Client/Server and the hardware and
software requirements needed.