Ok, sounds good.

Thanks for your help



>>Ok, so the Data Object contains the SQL code.
>>
>>If I have a Customer BO, I might have a GetCustomerByID procedure.
>>The BO would pass the Id to the Data object, which would run a
>>query for that Id? Sound right?
>
>Yup, that sounds right
>
>>
>>Now, say I wanted to call stored procs in the DO instead, how would I set up
>>the stored procedure? If I had the following procedure:
>>
>>

>>procedure GetCustomerById(nId as integer)
>>select * from customers where Id = nId
>>

>>
>>How would I return the results to the BO? Would you have the DO convert the
>>results to XML, or do that in the BO?
>>
>
>Since the SP won't return a cursor, the SP will have to do the conversion to XML. The DO should not be generic; it should be custom for each backend to take advantage of the database's strengths.
>
>>Thanks
>>
>>
>>
>>