>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.
>
An alternative in vfp3 is to index on field of choice, skip 49, get the value and use it in your query (where field <= value)...