>I have two tables that have been linked into a view. I have tried doing some SELECT * where (criteria) into cursor abc. I only want to return a total of no more than say 50 records regardless of whether the query result set contains 100 or 1000 records.
>
>I have tried using the cursorsetprop( 'maxrecords', 50 ) function, which always returns .t., but it always returns the entire result set.
>
>What am I doing wrong? Right now, I have resorted to doing the query to a table, then doing a second query where recno() < 50 into the final result set.
>
>tia. Stephen
Maxrecords property in cursorsetprop command should be used only with remote view, this property has no effect on local views.
Read help 'cursorsetprop'