>Thank you it works fine, i am thankfull for your work.
>
>Just a last question, in the connection string you use a data provider which is MSDASQL.
>
>I do not undestand the difference between "provider" and "data provider", because when i create an ole db initstring i can choose between MSDATASHAPE and MSDASQL provider.
>
>my english is a little poor excuse me.

---

Yes,
You can use both :) But only with MSDATASHAPE you can use "shape" commands. e.g. You could use a "compute" like this to emulate group totalling, grand totalling in a grid :

strShp = [  SHAPE ]+;
    [(SHAPE {select customer.cust_id, customer.Company, orders.order_id from customer ]+;
    [inner join orders on customer.cust_id = orders.cust_id where customer.cust_id like 'A%' } ]+;
    [	APPEND  ({select od.order_id, od.unit_price * od.quantity as ExtendedPrice  ]+;
    [ from orditems as od} AS rsDetails RELATE order_id TO order_id),  ]+;
    [ SUM(rsDetails.ExtendedPrice) AS OrderTotal, ANY(rsDetails.order_id)) AS rsOrders ]+;
    [COMPUTE  rsOrders, ]+;
    [SUM(rsOrders.OrderTotal) AS CustTotal, ]+;
    [ANY(rsOrders.Company) AS Comp ]+;
    [   BY   cust_id ]

If you don't need hierarchical sets you could just use MSDASQL and SQL syntax that you're familiar with fox. IMHO doing same in native fox SQL is like tooth pulling :) As in the code I sent before having multipl child recordsets w/o "shape" is impossible AFAIK (in one SQL). I wish you could see the results in Hierarchical flex grid to feel the difference. Honestly the shape syntax is extra complex :)
Cetin