Walter

I agree with you. Anywhere I'd use a VFP SELECT against local tables, I try to use SPT against remote tables, for the same reasons. Or I put the lookups in local tables- makes it much easier to replicate servers or allow disconnected use.

Without RVs, VFP is just a tool that allows native manipulation of local data but provides little other advantage I can see over other tools.

RVs *are* useful for Internet apps as well. My company uses views with field update property set for fields users should be able to change. With web connect we parse values sent back from the browser and update the corresponding view fields. This allows us to create html entry forms with any available fields without having to do anything else on the server. "Security" is covered by our selection of view fields and update settings for them- if a hacker sends data to change a primary key or a calculated $ field, that field's update property is not set in the view so the change is automatically discarded.

Using SPT or SP would require lots of work at the server.

Seems clear to me.

Regards

JR