look up - restrict duplicates and null values

look up - restrict duplicates and null values 



public static void lookupGroupDimension(FormStringControl _dimensionFocusControl)
{
    Query query = new Query();
    QueryBuildDataSource        queryBuildDataSource;
    QueryBuildRange             queryBuildRange;
    SysTableLookup              sysTableLookup;

    sysTableLookup = SysTableLookup::newParameters(tableNum(DimensionAttributeValue),_dimensionFocusControl);
    sysTableLookup.addLookupfield(fieldNum(DimensionAttributeValue,GroupDimension));

    queryBuildDataSource = query.addDataSource(tableNum(DimensionAttributeValue));
    queryBuildDataSource.orderMode(OrderMode::GroupBy);
    queryBuildDataSource.addGroupByField(fieldNum(DimensionAttributeValue, GroupDimension));
    queryBuildRange = queryBuildDataSource.addRange(fieldNum(DimensionAttributeValue, GroupDimension));
    queryBuildRange.value(SysQuery::valueNotEmptyString());

    sysTableLookup.parmQuery(query);
    sysTableLookup.parmUseLookupValue(true);
    sysTableLookup.performFormLookup();
}

debug access

debug access

lease go thorugh this location :

To access the local group policy

1. From the Start menu, choose Control Panel.
2. In Control Panel, double-click Administrative Tools.
3. In the Administrative Tools window, double-click Local Security Policy.
4. In the Local Security Settings window, expand the Local Policies folder.
5. Click User Rights Assignment.
6. In the Policy column, double-click Debug programs to view current local group policy assignments in the Local Security Policy Setting dialog box.
7. To add new users, click the Add User or Group button.

tts error

tts error

static void TheAxaptaResetTTS(Args _args)
{
    while (appl.ttsLevel() > 0)
    {
        info(strfmt("Level %1 aborted",appl.ttsLevel()));
        ttsAbort;
    }
    info("done");

}