>Thanks all for the answers I'm getting from you guys. You guys are great. Here is another one ........ Can you use a SELECT statement with [INTO] for a view like they are used for in a table?
That's basically what your doing with differen't syntax when you create a view with:
DEFINE SQL VIEW "View1" AS;
SELECT ...
FROM Table1
except now you can set all of the view properties which you can't have with a plain old cursor created with INTO.
If you're not familiar with the code that creates a view, get Genview.prg from the download section or run GenDBC.prg under \VFP\Tools\GenDBC to generate the code that can create a specified view or DBC. The VFP view designer is limited, so it's good to get familiar with view syntax for when you'll need to write your view in code.
HTH