General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only