Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table not recognized by Database
Message
 
To
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:
00754531
Views:
18
It looks like table was not removed properly from database. Either database still contain reference to the table (then try to modify/validate database and remove reference), or table header was not updated properly (then try to add it and remove).

>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