Yes John that's what I've been saying all along it has to do withapplication arquitechure and most of the times is where people is falling and what brings the projects down, not that they are developing in VFP or in .NET or Java, the language doesn't make alot of diference the arquitecture will.
>
just cause in VFP you open a table that has 500 000 records doesn't mean that in .NET or in that case in VFP connecting to SQL server you will return that 500 000 records to the client>
>I think that's it. In the 1990s there were large FP discussions about "filtered datasets" against backends. FP people were used to doing a "use myHugeTable" without pulling every record across the wire, and expected SQL server to work similarly. I don't think this is a dotNET issue at all, it is a filtered dataset issue.
Alexandre Palma
Senior Application Architect