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