how to capitalize all letters

There is a function available in AX strUpr(‘any string’) that can be used to convert the string to upper case.

ttsBegin;
while
select forUpdate myTable
{
myTable.Description = strUpr(myTable.Description);
myTable.update();
}
ttsCommit

how to get the current database name ?

There is a class available SysSQLSystemInfo, we can use that to get it.

SysSQLSystemInfo::construct().getloginDatabase();

Difference between today and systemDateGet methods

print today(); // will print system date on which AOS is running.

print systemDateGet(); // will print Ax session date.

To note the different you need to change the session date of AX (Tools Session date)

%d bloggers like this: