Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use View command rejected as dbf not found
Message
From
27/02/2005 09:54:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Use View command rejected as dbf not found
Miscellaneous
Thread ID:
00990973
Message ID:
00990973
Views:
58
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
Map
View

Click here to load this message in the networking platform