SqlSystem.sqlLiteral Method

Formats the input AX datatype to correct SQL type.

Syntax

public str sqlLiteral(
    anytype data, 
   [boolean forWhereClause, 
    boolean likeOperand, 
    boolean rightJustify, 
    int stringLength])

Run On

Server

Parameters

• data
  Type: anytype
  The input data.

• forWhereClause
  Type: boolean
  The where clause representation flag. By default equals false.

• likeOperand
  Type: boolean
  The like operand representation flag. By default equals false.

• rightJustify
  Type: boolean
  The justification of the field. By default the same as input data field.

• stringLength
  Type: int
  The length of the string.By default equals zero.

Return Value

Type: str
The formatted SQL type string.

See Also

Reference

SqlSystem Class