From the Messages table
Table "%1%" and its associated "!%1%" tables
are under different applications or locations.
Table can not be opened.
amcauley@sprezzatura.com
Sprezzatura Ltd
World Leaders in all things RevSoft
When do you want to reboot today?[/b]
</QUOTE>
—-
=== At 31 JUL 1998 10:26AM Cameron Revelation wrote: ===
<QUOTE>Simon,
Which table does this occur on? Verify one at a time, if possible.
Cameron Purdy
Revelation Software
</QUOTE>
—-
=== At 02 AUG 1998 07:29PM Simon wrote: ===
<QUOTE>Hi Purdy,
This is a data table. I can check the table information from 'LH table info'. But I got the error 'W428' when I verify this table. I can delete the table and create a new one, then everything is OK!
Thanks
Simon
</QUOTE>
—-
=== At 03 AUG 1998 07:33AM Cameron Revelation wrote: ===
<QUOTE>Hi Simon,
Were you able then to resolve the problem?
Cameron Purdy
Revelation Software
</QUOTE>
—-
=== At 04 AUG 1998 08:27PM Simon wrote: ===
<QUOTE>Yes, the problem is solved, but the data is lost!!!
I would like to know is there any way to recover the data from the collapsed table?
Thanks
Simon
</QUOTE>
—-
=== At 05 AUG 1998 07:48AM Cameron Revelation wrote: ===
<QUOTE>Simon,
According to the error number you reported, the table was not damaged in any way. However, a second table (probably an index table) was not available. If you remove the MFS's from the table, you should be able to attach it and work with it normally. (Indexes are implemented using MFS's.)
To remove MFS's manually, log into SYSPROG, attach the REVMEDIA table for the volume in question, and edit the * record for the table.
To attach the REVMEDIA from the System Editor command line:
run attach_table "", "REVMEDIA"
Then choose File, Open Record from the menu. When the dialog appears, click the Refresh button to refresh the list of tables. Double click on the REVMEDIA table in the list of tables. Select your table name from the list of rows; the row id will be in the format * where is the name you know it by and is probably the name of your app.
When you open the record, the second field will contain the MFS list. The list is delimited by value marks. Remove the MFS list (delete the contents of the line, but not the line itself) then save the record.
Next, re-attach that table. Verify you can access the data in it. When satisfied, save your database definition (e.g. from Database Manager) to update the attach image.
Cameron Purdy
Revelation Software
</QUOTE>
View this thread on the forum...