>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
Chung,
If you are using a "real" backend database (SQL Server, Oracle), you can get return values using the methods outlined in Message#
482249. If you are using VFP, then you can't run SPs via SPT with the current version (6). SPs are only run as a result of triggers. In VFP 7, we will have the ability to run SPs using the new OLE-DB provider.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao