Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Here's a new one on me.
>>
>>1. Create a new table in an existing database. Add a few records to the table. The database and the table are on a network in the same folder. modi database shows the table is in the database.
>>
>>2. run "validate database recover". Every cks OK.
>>
>>3. run "select * from newsurveys!surveyyears where _year < gnRptYear order by _year"
>>Produces an error that says there is no backlink from the table to the database, would you like to create one? ANS Yes.
>>Followed by an error that says the table must be opened exclusively.
>>
>>Can anyone explain this to me?
>
>This sort of ghosthunting looks to me like you have your table twice on the path, and somehow the wrong one pops up every now and then. Check for surveyyears.dbf along your path - if my hunch is right, you got two.
Good try but no cigar. There is only one file. It is a simple little lookup table with 1 field and about 20 records. I have deleted it completely and recreated it a couple of times but always with the same result. Is it possible the error is caused because another user has the database open?
Précédent
Suivant
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