General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Harry,
Are you saying that when you USE or REQUERY the view you get no records?
If so, is there any chance at all that there are 2 different CONTACT databases/tables at play?
good luck
>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only