General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only