BIGenerator::columnIdFromDbName Method [AX 2012]

Determines the ID of a field based on the database table and database column name.

Syntax

Note

The syntax of this method varies based on the version of Microsoft Dynamics AX that you are using.

  Microsoft Dynamics AX 2012 R3
          client server public static FieldId columnIdFromDbName(TableId tId, str columnName)

  Microsoft Dynamics AX 2012 R2 (SYS)
          client server public static FieldId columnIdFromDbName(TableId tId, str columnName)

  Microsoft Dynamics AX 2012 Feature Pack (SYS)
          client public static FieldId columnIdFromDbName(TableId tId, str columnName)

  Microsoft Dynamics AX 2012 (FPK)
          client public static FieldId columnIdFromDbName(TableId tId, str columnName)

  Microsoft Dynamics AX 2012 (SYS)
          client public static FieldId columnIdFromDbName(TableId tId, str columnName)

Run On

Called

Parameters

  • columnName
    Type: str
    The name of the column in the database.

Return Value

Type: FieldId Extended Data Type
The field ID of the field; otherwise, zero.

Remarks

There are two possible cases. One is that the name is too long and so is truncated and then appended to the field ID. The other is that the name is a SQL reserved word so the database field name ends with an underscore.

See Also

Reference

BIGenerator Class