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..