Share via

Codeunit "Type Helper"

ID 10
Namespace: System.Reflection

Properties

Name Value
InherentEntitlements X
InherentPermissions X
Permissions tabledata "Field" = r

Methods

Evaluate

procedure Evaluate(var Variable: Variant, String: Text, Format: Text, CultureName: Text): Boolean

Parameters

Name Type Description
Variable Variant
String Text
Format Text
CultureName Text

Returns

Type Description
Boolean

GetLocalizedMonthToInt

procedure GetLocalizedMonthToInt(Month: Text): Integer

Parameters

Name Type Description
Month Text

Returns

Type Description
Integer

CompareDateTime

procedure CompareDateTime(DateTimeA: DateTime, DateTimeB: DateTime): Integer

Parameters

Name Type Description
DateTimeA DateTime
DateTimeB DateTime

Returns

Type Description
Integer

FormatDate

procedure FormatDate(DateToFormat: Date, LanguageId: Integer): Text

Parameters

Name Type Description
DateToFormat Date
LanguageId Integer

Returns

Type Description
Text

FormatDate

procedure FormatDate(DateToFormat: Date, Format: Text, CultureName: Text): Text

Parameters

Name Type Description
DateToFormat Date
Format Text
CultureName Text

Returns

Type Description
Text

FormatDateWithCurrentCulture

procedure FormatDateWithCurrentCulture(DateToFormat: Date): Text

Parameters

Name Type Description
DateToFormat Date

Returns

Type Description
Text

GetHMSFromTime

procedure GetHMSFromTime(var Hour: Integer, var Minute: Integer, var Second: Integer, TimeSource: Time)

Parameters

Name Type Description
Hour Integer
Minute Integer
Second Integer
TimeSource Time

IsLeapYear

procedure IsLeapYear(Date: Date): Boolean

Parameters

Name Type Description
Date Date

Returns

Type Description
Boolean

LanguageIDToCultureName

Obsolete

This element will become obsolete from version 26.0. Use codeunit 43 Language, procedure GetCultureName instead.

[Obsolete(Use codeunit 43 Language, procedure GetCultureName instead.,26.0)]
procedure LanguageIDToCultureName(LanguageID: Integer): Text

Parameters

Name Type Description
LanguageID Integer

Returns

Type Description
Text

GetCultureName

Obsolete

This element will become obsolete from version 26.0. Use codeunit 43 Language, procedure GetCurrentCultureName instead.

[Obsolete(Use codeunit 43 Language, procedure GetCurrentCultureName instead.,26.0)]
procedure GetCultureName(): Text

Returns

Type Description
Text

GetOptionNo

procedure GetOptionNo(Value: Text, OptionString: Text): Integer

Parameters

Name Type Description
Value Text
OptionString Text

Returns

Type Description
Integer

GetOptionNoFromTableField

procedure GetOptionNoFromTableField(Value: Text, TableNo: Integer, FieldNo: Integer): Integer

Parameters

Name Type Description
Value Text
TableNo Integer
FieldNo Integer

Returns

Type Description
Integer

GetNumberOfOptions

procedure GetNumberOfOptions(OptionString: Text): Integer

Parameters

Name Type Description
OptionString Text

Returns

Type Description
Integer

OptionsAreEqual

procedure OptionsAreEqual(Value: Text, CurrentOption: Text): Boolean

Parameters

Name Type Description
Value Text
CurrentOption Text

Returns

Type Description
Boolean

IsNumeric

procedure IsNumeric(Text: Text): Boolean

Parameters

Name Type Description
Text Text

Returns

Type Description
Boolean

GetField

procedure GetField(TableNo: Integer, FieldNo: Integer, var Field: Record Field): Boolean

Parameters

Name Type Description
TableNo Integer
FieldNo Integer
Field Table System.Reflection.Field

Returns

Type Description
Boolean

GetFieldLength

procedure GetFieldLength(TableNo: Integer, FieldNo: Integer): Integer

Parameters

Name Type Description
TableNo Integer
FieldNo Integer

Returns

Type Description
Integer

TestFieldIsNotObsolete

procedure TestFieldIsNotObsolete(Field: Record Field)

Parameters

Name Type Description
Field Table System.Reflection.Field

IsPhoneNumber

procedure IsPhoneNumber(Input: Text): Boolean

Parameters

Name Type Description
Input Text

Returns

Type Description
Boolean

GetUserTimezoneOffset

procedure GetUserTimezoneOffset(var Duration: Duration): Boolean

Parameters

Name Type Description
Duration Duration

Returns

Type Description
Boolean

GetUserClientTypeOffset

procedure GetUserClientTypeOffset(var Duration: Duration)

Parameters

Name Type Description
Duration Duration

GetTimezoneOffset

procedure GetTimezoneOffset(var Duration: Duration, TimeZoneID: Text)

Parameters

Name Type Description
Duration Duration
TimeZoneID Text

EvaluateUnixTimestamp

procedure EvaluateUnixTimestamp(Timestamp: BigInteger): DateTime

Parameters

Name Type Description
Timestamp BigInteger

Returns

Type Description
DateTime

EvaluateUTCDateTime

procedure EvaluateUTCDateTime(DateTimeText: Text): DateTime

Parameters

Name Type Description
DateTimeText Text

Returns

Type Description
DateTime

FormatDateTime

procedure FormatDateTime(FormattingDateTime: DateTime, Format: Text, CultureName: Text): Text

Parameters

Name Type Description
FormattingDateTime DateTime
Format Text
CultureName Text

Returns

Type Description
Text

FormatUtcDateTime

procedure FormatUtcDateTime(DateTime: DateTime, DataFormat: Text, DataFormattingCulture: Text): Text

Parameters

Name Type Description
DateTime DateTime
DataFormat Text
DataFormattingCulture Text

Returns

Type Description
Text

GetCurrUTCDateTime

procedure GetCurrUTCDateTime(): DateTime

Returns

Type Description
DateTime

GetCurrUTCDateTimeAsText

procedure GetCurrUTCDateTimeAsText(): Text

Returns

Type Description
Text

GetCurrUTCDateTimeISO8601

procedure GetCurrUTCDateTimeISO8601(): Text

Returns

Type Description
Text

AddHoursToDateTime

procedure AddHoursToDateTime(SourceDateTime: DateTime, NoOfHours: Integer): DateTime

Parameters

Name Type Description
SourceDateTime DateTime
NoOfHours Integer

Returns

Type Description
DateTime

FormatDecimal

procedure FormatDecimal(Decimal: Decimal, DataFormat: Text, DataFormattingCulture: Text): Text

Parameters

Name Type Description
Decimal Decimal
DataFormat Text
DataFormattingCulture Text

Returns

Type Description
Text

UrlEncode

procedure UrlEncode(var Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

UrlEncode

[NonDebuggable]
procedure UrlEncode(var Value: SecretText): SecretText

Parameters

Name Type Description
Value SecretText

Returns

Type Description
SecretText

UrlEncodeSecret

Obsolete

This element will become obsolete from version 27.0. Use UrlEncode with secret text.

[NonDebuggable]
[Obsolete(Use UrlEncode with secret text.,27.0)]
procedure UrlEncodeSecret(var Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

UrlDecode

procedure UrlDecode(var Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

HtmlEncode

procedure HtmlEncode(var Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

HtmlDecode

procedure HtmlDecode(var Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

JavaScriptStringEncode

procedure JavaScriptStringEncode(Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

JavaScriptStringEncode

procedure JavaScriptStringEncode(Value: Text, AddDoubleQuotes: Boolean): Text

Parameters

Name Type Description
Value Text
AddDoubleQuotes Boolean

Returns

Type Description
Text

UriEscapeDataString

procedure UriEscapeDataString(Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

UriGetAuthority

procedure UriGetAuthority(Value: Text): Text

Parameters

Name Type Description
Value Text

Returns

Type Description
Text

GetKeyAsString

procedure GetKeyAsString(RecordVariant: Variant, KeyIndex: Integer): Text

Parameters

Name Type Description
RecordVariant Variant
KeyIndex Integer

Returns

Type Description
Text

ReadAsTextWithSeparator

procedure ReadAsTextWithSeparator(InStream: InStream, LineSeparator: Text): Text

Parameters

Name Type Description
InStream InStream
LineSeparator Text

Returns

Type Description
Text

TryReadAsTextWithSeparator

[TryFunction]
procedure TryReadAsTextWithSeparator(InStream: InStream, LineSeparator: Text, var Content: Text): Boolean

Parameters

Name Type Description
InStream InStream
LineSeparator Text
Content Text

Returns

Type Description
Boolean

TryReadAsTextWithSepAndFieldErrMsg

procedure TryReadAsTextWithSepAndFieldErrMsg(InStream: InStream, LineSeparator: Text, FieldCaption: Text): Text

Parameters

Name Type Description
InStream InStream
LineSeparator Text
FieldCaption Text

Returns

Type Description
Text

CRLFSeparator

procedure CRLFSeparator(): Text[2]

Returns

Type Description
Text[2]

LFSeparator

procedure LFSeparator(): Text[1]

Returns

Type Description
Text[1]

SortRecordRef

procedure SortRecordRef(var RecRef: RecordRef, CommaSeparatedFieldsToSort: Text, Ascending: Boolean)

Parameters

Name Type Description
RecRef RecordRef
CommaSeparatedFieldsToSort Text
Ascending Boolean

TextDistance

procedure TextDistance(Text1: Text, Text2: Text): Integer

Parameters

Name Type Description
Text1 Text
Text2 Text

Returns

Type Description
Integer

NewLine

procedure NewLine(): Text

Returns

Type Description
Text

GetMaxNumberOfParametersInSQLQuery

procedure GetMaxNumberOfParametersInSQLQuery(): Integer

Returns

Type Description
Integer

BitwiseAnd

procedure BitwiseAnd(A: Integer, B: Integer): Integer

Parameters

Name Type Description
A Integer
B Integer

Returns

Type Description
Integer

BitwiseOr

procedure BitwiseOr(A: Integer, B: Integer): Integer

Parameters

Name Type Description
A Integer
B Integer

Returns

Type Description
Integer

BitwiseXor

procedure BitwiseXor(A: Integer, B: Integer): Integer

Parameters

Name Type Description
A Integer
B Integer

Returns

Type Description
Integer

GetFormattedCurrentDateTimeInUserTimeZone

procedure GetFormattedCurrentDateTimeInUserTimeZone(StringFormat: Text): Text

Parameters

Name Type Description
StringFormat Text

Returns

Type Description
Text

GetCurrentDateTimeInUserTimeZone

procedure GetCurrentDateTimeInUserTimeZone(): DateTime

Returns

Type Description
DateTime

GetInputDateTimeInUserTimeZone

procedure GetInputDateTimeInUserTimeZone(InputDateTime: DateTime): DateTime

Parameters

Name Type Description
InputDateTime DateTime

Returns

Type Description
DateTime

ConvertDateTimeFromUTCToTimeZone

NOTE: The procedure's name is incorrect. This procedure converts the time from current client timezone to target timezone, instead of converting from utc to target time zone.

procedure ConvertDateTimeFromUTCToTimeZone(InputDateTime: DateTime, TimeZoneTxt: Text): DateTime

Parameters

Name Type Description
InputDateTime DateTime

The datetime based on current Client's time zone.
TimeZoneTxt Text

The destination timezone, such as 'GMT standard time','UTC','China standard time'.

Returns

Type Description
DateTime

The new datetime based on the detination timezone

ConvertDateTimeFromInputTimeZoneToClientTimezone

Convert the datetime from the specified timezone to current client's timezone.

procedure ConvertDateTimeFromInputTimeZoneToClientTimezone(InputDateTime: DateTime, TimeZoneTxt: Text): DateTime

Parameters

Name Type Description
InputDateTime DateTime

The datetime based on the specified timezone.
TimeZoneTxt Text

The specified timezone, such as 'GMT standard time','UTC','China standard time'.

Returns

Type Description
DateTime

The new datetime based on current client's timezone

IntToHex

procedure IntToHex(IntValue: Integer): Text

Parameters

Name Type Description
IntValue Integer

Returns

Type Description
Text

Maximum

procedure Maximum(Value1: Decimal, Value2: Decimal): Decimal

Parameters

Name Type Description
Value1 Decimal
Value2 Decimal

Returns

Type Description
Decimal

Minimum

procedure Minimum(Value1: Decimal, Value2: Decimal): Decimal

Parameters

Name Type Description
Value1 Decimal
Value2 Decimal

Returns

Type Description
Decimal

TransferFieldsWithValidate

procedure TransferFieldsWithValidate(var TempFieldBuffer: Record "Field Buffer" temporary, RecordVariant: Variant, var TargetTableRecRef: RecordRef)

Parameters

Name Type Description
TempFieldBuffer Table System.Reflection."Field Buffer"
RecordVariant Variant
TargetTableRecRef RecordRef

CalculateLog

procedure CalculateLog(Number: Decimal): Decimal

Parameters

Name Type Description
Number Decimal

Returns

Type Description
Decimal

GetAmountFormatLCYWithUserLocale

procedure GetAmountFormatLCYWithUserLocale(): Text

Returns

Type Description
Text

GetAmountFormatLCYWithUserLocale

procedure GetAmountFormatLCYWithUserLocale(DecimalPlaces: Integer): Text

Parameters

Name Type Description
DecimalPlaces Integer

Returns

Type Description
Text

GetAmountFormatWithUserLocale

procedure GetAmountFormatWithUserLocale(CurrencySymbol: Text[10]): Text

Parameters

Name Type Description
CurrencySymbol Text[10]

Returns

Type Description
Text

GetAmountFormatWithUserLocale

procedure GetAmountFormatWithUserLocale(CurrencySymbol: Text[10], DecimalPlaces: Integer): Text

Parameters

Name Type Description
CurrencySymbol Text[10]
DecimalPlaces Integer

Returns

Type Description
Text

GetAmountFormat

procedure GetAmountFormat(LocaleId: Integer, CurrencySymbol: Text[10]): Text

Parameters

Name Type Description
LocaleId Integer
CurrencySymbol Text[10]

Returns

Type Description
Text

GetAmountFormat

procedure GetAmountFormat(LocaleId: Integer, CurrencySymbol: Text[10], DecimalPlaces: Integer): Text

Parameters

Name Type Description
LocaleId Integer
CurrencySymbol Text[10]
DecimalPlaces Integer

Returns

Type Description
Text

GetAmountFormatDecimalPlaces

procedure GetAmountFormatDecimalPlaces(LocaleId: Integer, CurrencySymbol: Text[10], DecimalPlaces: Integer): Text

Parameters

Name Type Description
LocaleId Integer
CurrencySymbol Text[10]
DecimalPlaces Integer

Returns

Type Description
Text

GetXMLAmountFormatWithTwoDecimalPlaces

procedure GetXMLAmountFormatWithTwoDecimalPlaces(): Text

Returns

Type Description
Text

GetXMLDateFormat

procedure GetXMLDateFormat(): Text

Returns

Type Description
Text

CopyRecVariantToRecRef

procedure CopyRecVariantToRecRef(RecordVariant: Variant, var RecRef: RecordRef)

Parameters

Name Type Description
RecordVariant Variant
RecRef RecordRef

IsLatinLetter

procedure IsLatinLetter(ch: Char): Boolean

Parameters

Name Type Description
ch Char

Returns

Type Description
Boolean

IsDigit

procedure IsDigit(ch: Char): Boolean

Parameters

Name Type Description
ch Char

Returns

Type Description
Boolean

IsUpper

procedure IsUpper(ch: Char): Boolean

Parameters

Name Type Description
ch Char

Returns

Type Description
Boolean

Events

OnBeforeGetFieldLength

[IntegrationEvent(False,False)]
local procedure OnBeforeGetFieldLength(var Field: Record Field, var FieldLength: Integer, var IsHandled: Boolean)

Parameters

Name Type Description
Field Table System.Reflection.Field
FieldLength Integer
IsHandled Boolean

OnBeforeGetField

[IntegrationEvent(False,False)]
local procedure OnBeforeGetField(TableNo: Integer, FieldNo: Integer, var Field: Record Field, var Result: Boolean, var IsHandled: Boolean)

Parameters

Name Type Description
TableNo Integer
FieldNo Integer
Field Table System.Reflection.Field
Result Boolean
IsHandled Boolean

See also