>If have to update Stored Procedures in the database.
>
>But the client do not have FoxPro.
>
>What is the best way to update the stored procedure
The simplest solution is to purchase Stonefield Database Toolkit - SDT stores the content of the DBC, tables, indexes, views and SPs in a set of metadata tables external to the DBC; sending out the updated metadata tables and running SDT's Update() method, which can be built into your application, modifies the DBC and the contained items to comply with the metadata - it can replace SPs, add tables, indexes, views, revise structures of existing tables and the like automatically. It also handles free tables. The metadata can be used to validate, reindex, and within limits, repair the DBC and tables it describes. The runtime code can be incorporated into your app and redistributed on a royalty-free basis, allowing you to send out modifications as new metadata tables and apply them through your own app.
What version of VFP is the client running under? The runtime for VFP6 SP3 and later support the COMPILE command under the runtime.