John,
On another note. I did look into the properties collection on the RS, but did not find anyting that looked like what I wanted. There were some very interesting properties there though. Do you know of a good source of documentation of some of those properties?

>Hi Chad...
>
>Are you looking for something that limits what updates do and don't go through - similar to what we have in views???
>
>My guess is that if something like this is available - it will be exposed in the properties collection of the RecordSet object. What this collection contains and what RecordSets and Connections in general are capable of doing - is determined by the provider.
>
>As far as I can tell, we cannot do something like this:
>
>oconnection = createobject("adodb.connection")
>ocommand = createobject("adodb.command")
>oconnection.Open("testvfp")
>ocommand.activeconnection = oconnection
>ocommand.commandtext = '=dbsetprop("view1","view","wheretype",2)'
>ocommand.execute
>
>Perhaps the solution is to create a VFP COM Object that will do this work for you..