ReleaseUpdateDB::fields2WhereClause Method [AX 2012]

Gets a string to be used in the where clause in a direct SQL statement.

Syntax

server public static str fields2WhereClause(
    str _tableAlias1, 
    TableId _tableId1, 
    FieldId _fieldId1, 
    str _tableAlias2, 
    TableId _tableId2, 
    FieldId _fieldId2)

Run On

Server

Parameters

• _tableAlias1
  Type: str
  The name of a table.

• _tableId1
  Type: TableId Extended Data Type
  The ID of a table.

• _fieldId1
  Type: FieldId Extended Data Type
  The ID of a field.

• _tableAlias2
  Type: str
  The name of a table.

• _tableId2
  Type: TableId Extended Data Type
  The ID of a table.

• _fieldId2
  Type: FieldId Extended Data Type
  The ID of a field.

Return Value

Type: str
A condition string that is used in the where clause in a direct SQL statement.

Remarks

Check for sample usages in existing upgrade scripts when you use this method.

See Also

Reference

ReleaseUpdateDB Class