Hi Humberto,
Just to quote you :
the query with "Where !Deleted(table)" without join, don't work correctlyThe 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.
Liam O'Hagan
MCP VFP Desktop Apps