>>I have an application that calls functions in a procedure file. I'm using the SET PROCEDURE TO command at the begining of the app to identify the procedure file. I plan to upsize to SQL Server. Would there be an advantage to saving these functions as stored procedures in the database before upsizing ?
>>
>>John
>
>
> Yes..and in fact, you'll be better off using them now, inside VFP.
Craig, I believe you're right about using Stored Procedures if the functions are used across the whole application *AND* the data is not going to be used in other apps where these functions might not apply. If they are functions that are used in a single form or a single application then they might be better stored as form methods or application-level methods.
Barbara