Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Table not recognized by Database
I am unsure whether my problem is an issue of using tables or using SCAN (or worse still, Both!). I am opening a table (though it happens with several other tables) and then scanning it. I know the SCAN in itself works, as I have tried the code elsewhere. I have just done a similar scan on another table (included in the dataenvironment) in code a few lines earlier that works fine. I tried including and excluding the table from the dataenvironment, with the following results:
1. Problem_Table Not included in Form dataenvironment
USE Problem_Table
SCAN FOR Problem_Table.field = cVARIABLE
> Error “Table not marked belonging to dB. Create Backlink?”
2. Problem_Table Added to Form dataenvironment
*USE Problem_Table
SCAN FOR Problem_Table.field = cVARIABLE
> Nothing found by SCAN
I have played around with EXCLUSIVE settings (at one point I got a "Must be opened exclusive" error; opening table AGAIN ; tables appear to have the same properties – checked Status of environment with DISPLAY STATUS; Validated dB; the problem table works fine in another form; Removed & added table; DISPLAY DATABASE shows accurate info; Table and database are in standard folders (ie no need for Stonefield).
Any help greatly appreciated.
Cheers,
Blair
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