Better make that
www.Salias.com.ar/tierAdapterAlan
>Oi, Rodolfo.
>
>[snip]
>>I think, until here, I have no problems. My first doubt is how define my interface to get a list of customers. Some examples:
>>
>>FIRST OPTION - Use a generic method.
>>
oCustomers.ListCustomers(cSQL) -> I pass a Select SQL statement and receive a XML string with all records resultant for this SQL statement. For example:
>>oCustomers.ListCustomers("Select * From Customers Where Name Like '%TEST%' Order By Name")
>>oCustomers.ListCustomers("Select * From Customers Where Id between 100, 200 Order By Name")
>>oCustomers.ListCustomers("Select * From Customers Where Id between 100, 200 Order By Id")
>>
>>SECOND OPTION - Use various specifics methods.
>>
oCustomers.ListCustomersByName(cName, cOrder) -> I pass a String to be used in Where statment (cName) and other to be used in Order statment (cOrder). For Example:
>>oCustomers.ListCustomersByName("%TEST%","Name")
>>oCustomers.ListCustomersByName("%TEST%","Id")
>>
>>
oCustomers.ListCustomersByIdRange(iId1, iId2, cOrder) -> I pass two integers to be used in Where statment (iId1 and iId2) and other to be used in Order statment (cOrder). For Example:
>>oCustomers.ListCustomersByName(100,200,"Name")
>>oCustomers.ListCustomersByName(100,200,"Id")
>[snip]
>
>This is a common problem, and it has to do with your overall strategy, so you better define what's best for you and stick with it.
>
>Take a look at my study TierAdapter framework at
www.Salias.com.ar/tierAdpater. The only docs by now are PPTs for the presentation (Spanish/English available). I hope to be writing down an article with more detail sometime soon. Anyway, it is not too complex, because the real purpose is to explain those things. There is a little sample app based on the VFP/SQL Northwind database.
>
>And, of course, you know what to do if you have any doubts. 8-)
>
>See you,