Use In lines (GMAINT) under Maintenances in the Development > Utilities block to modify the data in any table in the database without performing data validation or database integrity checking.
Warning: This function should only be performed by a developer. Access to this function should not be provided to unauthorized users. (Only users with the administrator profile ADMUSER should access this function.) Inappropriate use may corrupt the integrity of the data stored in the database.
-
Warning: This function should only be performed by a developer. Access to this function should not be provided to unauthorized users. (Only users with the administrator profile ADMUSER should access this function.) Inappropriate use may corrupt the integrity of the data stored in the database.
- After selecting the folder and table to perform maintenance on, click OK.
- By default, the current folder is proposed; however, you can enter the name of another folder using the following syntax:
- Folder: Directly enter the name of the folder. In this case, the folder must be accessible on the same server and service.
- server@Folder: Enter the name for the server where the folder is located. An adxd service must work on the current service number to allow the connection.
- Server:service@Folder: This uses the same principle as server@Folder, but the service number can be different. For example, this gives the syntax server_01:1811@DEMO.
- Warning: These last two syntaxes assume the folder exists on the remote server. Entering an incorrect network name can result in a long wait time.
- This function is primarily used to view data within the Sage X3 database.
- Records can be modified, created, or deleted.
- Key values appear in the first section of the window, while all other fields are listed spanning across several tabs.
- The code in the header area is associated with each record.
- The table fields are displayed over several tabs (not all are necessarily filled in alphabetical order.
-
Sage X3 and Sage Software are trademarks of Sage Software, Inc. Microsoft SQL Server, Microsoft SQL Enterprise Manager and SQL Server Management Studio are registered trademarks of Microsoft Corporation. Oracle is is a registered trademark or Oracle Corporation. All other product names used here are trademarks or registered trademarks of their respective owners.
-
