>>Hi, all
>>I am working on a Client-Server Application, all of its front-end and back-end is developed using VFP6. Could anybody tell me how to call the back-end stored procedure? And, how to get the value that procedure returned?
>>TIA
>You might download the ADO Query Analyzer in files section. It is packaged with an ADO COM service.

Or just use SQL Passthrough. The syntax for calling a stored procedure that returns a value might be something like:
(this is assuming you already have a connection number to the server)

RetVal = ''
SqlCmd = '{CALL pStoredProc (?@Retval)}'
ResultCode = SQLEXEC( ConnHandle, sqlcmd )

This will call the stored procedure "StoredProc", passing it the RetVal. The "@" means that the stored procedure is returning a value and that this variable will contain that value.

There should be more info in the VFP Developer's Guide under Client Server topics.

HTH,
George