Edit the target dialog box

The fields in the target dialog box are read-only by default. You can modify this attribute in the table’s dbedit xml by setting the WritableTargetForm to True.

To edit the target dialog box

1. Log on as dnaInstaller.

2. Navigate to %DNAInstallRoot%\ADE\config\ADE\DBEdit\Schema\baseline.

3. Copy the file of the table that you want to modify to %DNADataRoot%\ADE\config\ADE\DBEdit\Schema\custom, and rename it to <TableName>.alter.xml.

4. Add WritableTargetForm="true" to the desired field. You can remove any unmodified fields. For example:

   <Field Name="description"

   RowLabel="Description"

   ColumnLabel="Description"

   ToolTipText="Description of the record"

   TabOrder="20"

   IsRequired="false"

   IsReadOnly="false"

   IsVisible=" true"

   WritableTargetForm="true"

   DisplayWidthToUse="Maximum">

   </Field>

5. On the desktop, double-click the Windows PowerShell for DNA shortcut.

   Windows PowerShell for DNA opens.

6. Execute the following commands:

   set-silo ADE

   DBEditDisplaySchemaMerge

   You can now edit data in the target dialog box using the Advanced Database Editor (ADE).

7. Where Remote and/or Remote_SSO is used, complete the following steps:

   1. Copy the newly compiled %DNADataRoot%\ADE\config\ADE\DBEdit\DBEditSchema.xml file to the target servers running Remote Client Service (RCS).

   2. Place this file in folder %DNADataRoot%\RCS\config\ADE\DBEdit.

      This folder location will exist if the system was prepared for Remote ADE operation.

   3. Restart RCS.