Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table not recognized by Database
Message
From
18/02/2003 12:05:34
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00754296
Message ID:
00754523
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform