General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Use View command rejected as dbf not found
This is a problem with parameterised views on a local network.
I've found and implemented various suggestions about creating the views in a temp database. Got all that working.
The line that's giving me gip is
USE temp!contacttemp IN 0 SHARED ALIAS CONTACTS
at which point it stops with
[path]\contactemp.dbf does not exist.
what, however, has thoroughly confused me is that if I cut and paste the offending line into the command window, it then executes faultlessly and I can resume the program, ignore the error, and peruse my parameterised view without a hitch.
The exact sequence I'm using is:
open database temp
set database to temp
create view contacttemp...
dbsetprops...
USE temp!contacttemp IN 0 SHARED ALIAS CONTACTS
set database to CONTACT
has anybody got the faintest idea why I should get this behaviour?
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