>Thanks. I am attempting to use the genview program. I am either getting a parameter error or a message box telling me that it isn't a cursor. The readme file explained more on what the program was for than explaining how to use it (which is probably a no brainer to some). Could you clarify how to utilize this tool?
VFP9 and still using Views when CA is here? :-)
Just kidding.
try this in command window:
CLOSE ALL
CLEAR ALL
OPEN YourDatabase EXCLUSIVE
MODIFY VIEW TheNameOfTheView
Then click on SQL button in the toolbar.
BTW using Views was/is very helpful when you need to get just a portion of the records.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.