Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
To your #1: Do you have database open? If so, did the table in the past belong to database?
Yes, Yes.
To your #2: When table is included into Form Dataenvironment, it appears with another alias, like "Cursor1". Check object properties in Form Dataenvironment.
No, correct alias.
>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
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