I set all of my fields in one list screen to have a return screen value of 0, and now I can't access my database.
Submitted by dlts on Tue, 07/28/2009 - 16:07
To fix this issue, you need to set at least one return screen value to something other than 0. The directions for this through Navicat are as follows:
- Find out the tableId of the table in the DatabaseTables table that is causing problems.
- In the DatabaseFields table use the Filter Wizard to filter for that tableId. It will look something like this tableId is equal to 43
- Set the return screen order of one of the fields to something other than 0.
- The database should now work.
Alternativly you can run the following sql command:
UPDATE DatabaseFields,DatabaseTables
SET DatabaseFields.returnScreenOrder = [new return screen order]
where DatabaseFields.fieldName='[field name]' and DatabaseFields.tableId = DatabaseTables.tableId and ->DatabaseTables.tableName='[table name]'
- Login to post comments
Application Bugs
Bug reports can
be transmitted using the bug report function in the application. Otherwise they should be sent to the AT project at info@archiviststoolkit.org
Other comments or questions should also be sent to info@archiviststoolkit.org
Copyright 2006-2009