>Hi,
> What is the main reasons of using stored procedure?
> What functions that usually wrote as stored procedure?
> How to call stored procedure (VFP / SQL database)?
>
>
>Thankl you
Anything function that needs to be used by the database itself is put in a stored procedure. The best examples for VFP are Primary Key generation and Referential Integrity, but there could be others. For example, you may need to do some calculations on the stored data.
To call a stored procedure in VFP, make the call as one of the triggers or default value entries. There is an example of PKs on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer