You are either one of the most patient people i know or a masochist to participate in this discussion.

I went to a MSDN dog-and-pony yesterday. I know many people will be shocked that none of the topics involved VFP. It was about .Net and SQL Server.

My first observation was, as I suspected, the average age at the event was lower then VFP events I have attended. But I also found it interesting that folks were asking quite a bit of sophisticated questions, so I knew there were some very, very good developers present. Yet, no one asked for easier data handling. Could it be that there are readily available class libraries, such as the data handling application block, to make things easy?

I want access to some of the drugs people here obviously use. I am working on some very large accounting systems now. How can someone tell you that doing an accounting system in .Net does not test .Nets data ability?

This is extremely comical.



>I know, However this only works on PKs, not on other columns. OF course there are a number of feartures like SET NEAR and SET FILTER, TAG orders etc that don't come in ADO.NET
>
>I believe your words were 'no SEEK on local data'. You are now qualifying your statement.
>
>Correct, to create a primary key and then a FIND (analogous to a SEEK), it must be on a unique key.
>
>You can do a ROWFILTER. You can also create multiple dataviews on a datatable with different sort orders. You can also specify in a lookup (by using different special characters) whether you want an exact match or partial match.
>
>As I mentioned months ago, I wrote a generic LOCATE function that receives a collection of column(s) and a lookup value to return the datarow(s). I am not denying that I had to write some code to do the same things that VFP has in one command.
>
>But this argument that it 'adds complexity, increases the possibility of bugs' is no more valid than it would be if argued against VFP people who wrote some additional code to do things with, say, the Win API that VB supported 'out of the box'.
>
>Kevin