>>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.

I thought when code was placed in VFP stored procedures that it wouldnt automatically get upsized to SQL Server? Meaning if John is going to take the time to manually move his code into stored procedures in VFP, wont he have also manually recreate the same stored procedures in SQL Server after the upsized wizard has done its thing?

Roxanne M. Seibert
Independent Consultant, VFP MCP

Code Monkey Like Fritos