Data Access Worldwide Knowledge Base
Article Text
QUESTION:
I am migrating from revision 7 to revision 12) and codemast/codetype have been moved from 207/208 to 253/254. I want to move (these) tables in the filelist of my customer too to a different slot but I cannot use DataBase Builder. How do I do it.
ANSWER:
Moving the filelist entry is quite simple. You copy the current values from the filelist entry using the attributes DF_FILE_ROOT_NAME, DF_FILE_DISPLAY_NAME and DF_FILE_LOGICAL_NAME into variables, set the attributes to an empty string (or constant) and set the attributes of the new slot to the copied values.
But... if you do it right when moving a table to a different slot you need to check the relationships of all other tables to see if any of them relates to the table that you move.
Enclosed is a little view that demonstrates the move of a self chosen table in the filelist to a different slot checking and changing the relationships if you tick the checkbox.
Contributed By:
Vincent Oorsprong
Company: Data Access Worldwide
email: vincent.oorsprong@dataaccess.eu
Web Site: http://www.dataaccess.eu
Web Links Related to this Article
File MoveFileList.vw
URL=http://www.dataaccess.com/KBasePublic/Files/2259.MoveFileList.vw
Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2010 Data Access Corporation. All rights reserved.
| The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply. |