>I'm a little confused with your response. Can you explain more. Below is the view's sql.
>
>SELECT Workorders.workordersid, Workorders.number, Workorders.quantity,;
> Workorders.requestdate, Workorders.customernameview,;
> Workorders.partnumberview, Workorders.requestbynotes;
> FROM ;
> data1!workorders;
> WHERE Workorders.status = ( "O" );
> AND Workorders.requestdate > ( {^2000/01/01} );
> ORDER BY Workorders.requestdate, Workorders.customernameview,;
> Workorders.number
>
>DBSetProp(ThisView,"View","SendUpdates",.T.)
>DBSetProp(ThisView,"View","BatchUpdateCount",1)
>DBSetProp(ThisView,"View","CompareMemo",.T.)
>DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
>DBSetProp(ThisView,"View","FetchMemo",.T.)
>DBSetProp(ThisView,"View","FetchSize",100)
>DBSetProp(ThisView,"View","MaxRecords",-1)
>DBSetProp(ThisView,"View","Prepared",.F.)
>DBSetProp(ThisView,"View","UpdateType",1)
>DBSetProp(ThisView,"View","UseMemoSize",255)
>DBSetProp(ThisView,"View","Tables","data1!workorders")
>DBSetProp(ThisView,"View","WhereType",3)
>
>DBSetProp(ThisView+".workordersid","Field","DataType","N(6)")
>DBSetProp(ThisView+".workordersid","Field","UpdateName","data1!workorders.workordersid")
>DBSetProp(ThisView+".workordersid","Field","KeyField",.T.)
>DBSetProp(ThisView+".workordersid","Field","Updatable",.F.)
>
>DBSetProp(ThisView+".number","Field","DataType","C(10)")
>DBSetProp(ThisView+".number","Field","UpdateName","data1!workorders.number")
>DBSetProp(ThisView+".number","Field","KeyField",.F.)
>DBSetProp(ThisView+".number","Field","Updatable",.F.)
>
>DBSetProp(ThisView+".quantity","Field","DataType","N(5)")
>DBSetProp(ThisView+".quantity","Field","UpdateName","data1!workorders.quantity")
>DBSetProp(ThisView+".quantity","Field","KeyField",.F.)
>DBSetProp(ThisView+".quantity","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".requestdate","Field","DataType","D")
>DBSetProp(ThisView+".requestdate","Field","UpdateName","data1!workorders.requestdate")
>DBSetProp(ThisView+".requestdate","Field","KeyField",.F.)
>DBSetProp(ThisView+".requestdate","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".customernameview","Field","DataType","C(50)")
>DBSetProp(ThisView+".customernameview","Field","UpdateName","data1!workorders.customernameview")
>DBSetProp(ThisView+".customernameview","Field","KeyField",.F.)
>DBSetProp(ThisView+".customernameview","Field","Updatable",.F.)
>
>DBSetProp(ThisView+".partnumberview","Field","DataType","C(30)")
>DBSetProp(ThisView+".partnumberview","Field","UpdateName","data1!workorders.partnumberview")
>DBSetProp(ThisView+".partnumberview","Field","KeyField",.F.)
>DBSetProp(ThisView+".partnumberview","Field","Updatable",.F.)
>
>DBSetProp(ThisView+".requestbynotes","Field","DataType","M")
>DBSetProp(ThisView+".requestbynotes","Field","UpdateName","data1!workorders.requestbynotes")
>DBSetProp(ThisView+".requestbynotes","Field","KeyField",.F.)
>DBSetProp(ThisView+".requestbynotes","Field","Updatable",.T.)
>
>
>
>There is an index on 'status' and 'requestdate' in the workorders table.
>
>Thanks
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","WhereType",3)
These 2 together make ýt slower.
DBSetProp(ThisView,"View","WhereType",1)
should make faster.
Cetin