>Given a SQL Server or Oracle backend, how else would you propose finding a single row out of millions... Even if designing a system using native tables, to ensure an upgrade path using a SEEK against base tables strikes me as a bad idea.
>
Mark and Others,
Hey guys calm down here. No one is saying that SEEK is the way to write C/S apps. However seek is not a bad thing either. IN fact the simple possibility that I can use a R-View to get records and then I can munge those records using xBase in the VFP code is what gives VFP its power over other alternatives development languages.
In my experience I have not seen SEEK or SEEK() misused and abused often. They are usually used right where they add to the system and their performance and scalability are fine. Remember, one can create indexes on views and then SEEK in them. Therefore SEEK is NOT on my list of misused and abused VFP commands.