Visual LANSA Forum

Hello,

Is it possible to clear and reuse a PRIM_JSON.Writer object? e.g. within a list

Define_Com Class(#XPRIM_JsonWriter) Name(#writer)

Selectlist Named(#Products)

#Writer.SetOutputToString
#Writer.BeginObject
#Writer.BeginObject Name('outputData')
.
.
#Writer.EndObject

Insert Fields ...

Hello,

In the case where a specific field of an "Other file" has a different name in the LANSA Repository than the name of the field in the Other file, which field name do I use in the Select_Sql command?

best,
Sotiris

Hello,

thank you for your replies.

However there is probably something that I am missing here because in my setup (LANSA IDE WINDOWS - IBM MASTER), when the object (e.g. a function) is checked out read only, I can make changes to it, save it and send it via check in. The only difference that I ...

Hello,

Can you tell me the difference between check out and check out Readonly?

According to Lansa documentation:

Check out is used to copy the definition of an object that is currently stored in the LANSA for i Master Repository into a Visual LANSA Slave Repository. You can check out an object ...

Hello,

is it possible somehow to benchmark my RDML code to find out if a code optimization worked?

eg. the following pseudocode when GetTicks gives the time, say in millisecond accuracy.

GetTicks1
Execute Code
GetTicks2

DIFF = GetTick2 - GetTicks1
Display(#DIFF)

best,
Sotiris

Hello,

Are there equivalent command or built-in functions to intrinsic RDMLX string functions Replace and ReplaceAll in RDML?

best,
Sotiris

Hello,

is there any way to get the current date in ISO format only with RDML (no RDMLX)?

e.g.
Define Field(#CURDATE) TYPE(*CHAR) LENGTH(10) DEFAULT('''2023-01-02''')

note TYPE(*DATE) wont work for RDML

thanks,
Sotiris

Hello,

I found this similar question in the forum

https://forum.developer.lansa.com/viewtopic.php?t=1882

Note that currently it will still not work for files > 16M, but it will work for anything < 16M (whereas if you manually encode the file into base64 string using XPRIM_Binary, your base64 ...

After trying also with COMMIT the above error unfortunately persists:

========= Messages issued by the task you are currently performing =========
DELETE FROM LANSAMOD.TESTFILE where ACTIONID = 'C ' ;SELECT @@ROWCOUNT;COMMIT
SQL error for table N/AVAIL when using DBM function X_DBM_Open_Cursor ...

Hello,

thank you for your replies.

I tried BrendanB's solution

#KEY_FIELD := #ACTIONID

#SqlStatement := 'DELETE FROM ' + #FILELIB + '.' + #FILENAM + " where ACTIONID = '" + #KEY_FIELD + "' ;SELECT @@ROWCOUNT;"

Message Msgtxt(#SqlStatement)

Select_Sql Fields(#std_count) Using(#SqlStatement ...

Hello,

I need to use the command Delete From_File(MYFILE) WITH_KEY and possibly others

where MYFILE is a variable determined at run time and prone to change.

For example say that there is a file named ANOTHER_FILE with a specific string field (MY_FILENAME_FIELD) that denotes a file name
Is ...

I just noticed a recent post with the title

Crude Complexity Rating Fatal

and within Dino's comment answers more or less this question too.

best,
Sotiris

Hello,

In certain functions after compilation I receive the following warning:

Note: CEICR (Crude Element Complexity Rating) for this function is: MODERATE

Can someone explain what this metric means (it is my suspicion that is related with code optimization?) and how can be improved?
It seems ...

Hello Dino,

thank you for your answer.
Currently we are using LANSA 13.

I have been provided by my organization with a template as a starting point but there are several small details that is hard to find the relevant documentation.

For example the following field is defined:

DEFINE FIELD(#PB ...

Hello everyone,

I am looking for a beginner friendly Tutorial / Guide (if any) that describes with examples the relevant LANSA commands that can be used to
Display/ Request / user input, etc information on a workstation, in other words any resource that shows how to create a program that displays ...

Hello everyone,

Is it possible to change the description of a function after it was created and if yes how?

best regards,
Sotiris