Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement