John:

This is right out of the VFP help under DBGETPROP. Notice is says 'Read Only'.

"SQL C The SQL statement executed when the view is opened.
Read-Only."

Ya, gotta do it like I described to you if you want to change the underlying SQL during runtime.

Charlie