>>I just purchased Web connection and in working with the documentation, Rick uses a select statement for building a Cursor. Even when building a one record cursor.
>>
>>My question is why. What benefits will I get from a select statment that I couldn't get from seek, scatter, gather.
>>
>>Any and All opinions are welcome, even if your NOT an MVP <s>
>>
>>Thanks
>>
>>Alan
>
>Hi Alan,
>
>Let me ask you why would you want to write a program if you can achive the same result with one command - select statement?
>IMO a select statement is much more readable/maitainable than procedural code and in most cases even more efficient.
>Secondly, you can use select stament with any backend (VFP, MS SQL Server, Oracle, e.t.c.). I cannot say the same about procedural code.

In other words, scalability issue, but just make it sure that the commands are purely ANSI-SQL, otherwise, you'll be in trouble if you want to shift from one database to another with the same code.