Ok, I can understand that. Where do Stored Procs fall into
this schema?

And, if the BO's are using SQL Selects to access the data, then where's
the Data Class in all this?



>IMO, you're better off having the data objects pull data from the DBFs using SQL statements, then using CURSORTOXML to convert the data. When you move to SQL Server, you shouldn't have to make too many changes to the data object code.
>
>>I think I misspoke my intentions a bit.
>>
>>I'm converting the VFP app into a 3 tier app first, then
>>later to .Net.
>>
>>First the app will be converted to look at the VFP DB through
>>BO's and a data class, returning data as XML. These VFP components
>>will be built as COM objects.
>>
>>Then, after this is done, I will convert the data to SQL. Then after
>>that, I will convert the app to .Net.
>>
>>So, can I use a CA to call a stored proc in the VFP DB and get the results
>>back as XML? Can you point me to an example?
>>
>>And, I'm still not sure where the right place for each piece is. It seems
>>that if I place the code to convert the data to XML in the stored proc, then
>>any process calling the SP gets the data back as XML. THis seems like it should
>>be in the BO.
>>
>>I would appreciate your comments on this design schema.
>>
>>Thans
>>