>I do not agree with Jeff's statement about all of the xBase commands being a poor choice. If that were true then tere would be no reason to use VFP. I say SET FILTEWR is oftena bad choice because other commands can create a result set of teh desired records in a better fashion. ONce I've got the result set I probably would be using LOCATE and/or SEEK to move around in the result set.


Jim, I never said that the SET FILTER / RELATION / SKIP and SEEK commands were a poor per se. What I did say, in my original response to Walter, was that these commands are easy for a developer to rely upon at the expense of not learning SQL and designing apps which can be scaled.

It's all to easy to fall into this trap and be unprepared when the day comes where SQL Server is required.

The Fox community has always taken pride with being able to tackle database applications where others have found it more difficult and costly. I'd hate to see our edge fall by the wayside.