Hi Humberto,

Just to quote you :
the query with "Where !Deleted(table)" without join, don't work correctly

The query you posted clearly has a Deleted() condition. This is your problem! You shouldn't use Deleted() in a multi-table query.

Use Set Deleted On instead.

Regards,

Liam





>Course Liam!
>
>...
>...
>&& Delete the detail.
>Delete From ordersdetail Where idorder == orders.idorder
>
>&& Delete the header.
>Delete In orders
>
>&& Move to first order and reload the detail.
>Go Top In orders
>Select idproduct,name,unitcost,quantity,unitcost*quantity as total ;
> From ordersdetail Left Outer Join products ;
> On products.idproduct == ordersdetail.idproduct ;
> Into Cursor curDetail Readwrite ;
> Where ordersdetail.idorder==orders.idorder And !Deleted("ordersdetail")
>...
>...
>
>The result is a "curDetail" empty cursor after de query.