We have moved data from one directory to another:

  \arev\data\sub-a   -]  \revsoft\data\sub-a

            \sub-b                    \sub-b

             .....

Using Detach and Attach_Table we were able to fix up

the data from all sub-directories except one.

Using the editor shows there is no data in the files,

or the data files.

Remove Table gives:

  SYS1303 Table list in the volume record does not

  sync. with the SYSTABLES record.

Delete Table gives:

  FS100  Record '"' does not exist.

There seems to be a mis-match between SYSVOLUMES and

SYSTABLES. Synchronising the database seems to have no

effect.

Is there a simple command which will remove the list of

files from the database so that they may be re-attached

later. We wish to also us the Attach/Detach to

temporarily use an old version of data then switch back.

Chris,

What you would want to do is after removing the old tables use the Define_Database. Define_databse takes 4 parameters: Database name, overwrite flag (pass as true), null and null.

after redefining the database you should be able to attach the new location and then define database again to add the tables into the .dbt file.

John Revelation

Chris,

There seems to be a mis-match between SYSVOLUMES and SYSTABLES.

Download the SyncDB utility and check it into your SYSPROG application as the SYSPROG user. I believe it includes a form called SYNCDB which you need to execute from your application to resolve the mismatch.

[url=/WebSite/discuss.nsf/09d90959a1a106db8525652c0042cb86/53e9bcd971c8490c85256467004f3773/$FILE/Syncdb.zip]website_discuss.nsf_09d90959a1a106db8525652c0042cb86_53e9bcd971c8490c85256467004f3773_body_0.ca4_openelement_fieldelemformat_gif

Cameron Purdy

Revelation Software

View this thread on the forum...