That did not work because you have to USE the view before you can set properties on it. I need to make it clear that my problem is with "CREATE SQL VIEW" not "USE {viewname}"

When I changed the SELECT in the CREATE SQL VIEW to

SELECT * from titles LIMIT 1 (LIMIT is the same as VFP TOP)

the CREATE SQL VIEW worked instantly (i.e. it did not select all records). I thought I had solved the problem.

However, when I want to USE the view, you cannot change this limit on the view (LIMIT is part of the SQL propertly, which is read only). The "maxrecords" property has no effect.

Furthermore, if you include a WHERE statement (needed to make the VIEW useful), the LIMIT is ignored and I am again waiting for a Gig of data to download.

I'm still stumped.