Thanks Mark,

I used your idea and did get it working with ODBC - I added this stored procedure:

PROCEDURE ClearViews()
	IF USED('TestView')
		USE IN TestView
	ENDIF
	RETURN .F.
ENDPROC

and I put this after the first SQLEXEC

SQLEXEC(lnConnection, [SELECT * FROM TestTable WHERE ClearViews()])

>Not with ODBC. Based on info I gleaned from previous threads here, if you use OLE DB provider for VFP, you could do this by calling a Stored Proc in the DBC that would either requery the view for you or close the view.