Lynda,
Did you try to open the prodata.dbc before processing the view?
For a table that is in the DBC, you can open it either by giving the fullpath and file name (as you would do for a free table) or just the table name (as it is stored in the DBC).
So, you can give
OPEN DATA PRODATA
CREATE SQL VIEW AS SELECT * FROM ARCUST01
or
CREATE SQL VIEW AS SELECT * FROM c:\pro71\ardata01\arcust01.dbf
Since you mention a form, maybe the form is set to have a private data session, in which case you would have to put the following line in the Load Event of the form
SET DATABASE TO prodata
HTH
- Dan
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