>>>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
I somewhat agree with you. The way I do it, data validation procedures are put in the DBC as
a stored procedure. Anything else is on the form or application level.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer