Hi,

Could the view possibly be opened with NoDataOnLoad = .T. ??
If so just issue a Requery on the view.

HTH
Dennis

>between
>CREATE SQL VIEW CQRY AS SELECT * FROM CONTACT!CONTACTS WHERE TOWN='NEWPORT'
>which returns no records from a given database
>
>and
>
>SELECT * FROM CONTACT!CONTACTS WHERE TOWN='NEWPORT' INTO DBF 'CQRY'
>
>which returns 106 matches from the same database?