Thankyou Dennis,
see my reply to Dan.

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