Visual LANSA Forum

Thanks, that does the trick!

I am attempting to display a certain number of columns in a list based upon a user selecting a value from a drop down.
If the user chooses the value of 5 (years), data should be shown in all 5 columns. However, if they choose 3 or 4, I set the column's visibility as "False". I've tried setting the ...

Lansa support provided a "Hot fix" to resolve this issue (LANSA for IBM i Hot Fix - HF150048).

In our case it is not a browser issue. I've tried Chrome, Edge and Firefox.

We applied the most recent EPC (EPC150050) on our test AS400.

This release has introduced an issue where a horizontal scroll bar is now appearing at the bottom of every List.
The scroll bar appears even though the data in all the columns are fully visible already.
In fact, if you attempt to use ...

We applied the most recent EPC (EPC150050) on our test AS400 and this took care of my original issue.

However, it looks like this EPC introduced a different issue for us.....

Horizontal scroll bars are now appearing at the bottom of every List, even though the width of the list does not require ...

I'm using a couple different iListCellDesign reusable parts within an expandable list. I'm using one to change color of a cell when its value is less than 0.
This seems to work as desired. However, for the other iListCellDesign cell, I'm merely defining the contents of the cell (an item number) as ...

I doubted that there was quick "Linear Regression" built-in function, but at least knowing these intrinsic functions exist will help in us developing our own logic. Thanks

We are developing a Visual Lansa Sales Forecasting system.

One potential method we may forecast is through the use of a "trend" in sales history using multiple years of sales data.

If we are asked to calculate this trend through the use of Linear Regression calculations (e.g. X and Y values, slope ...

You need to use SQL to read or write BLOB's in RPG. Are you trying to read or write?


I need write to a BLOB field on a file (not a display). My input file has text data in multiple fields that I'm going to be "concatenating" and writing to the BLOB field.

So far I'm just jumping from one ...

Thanks for the list. The ones I was looking at didn't include type "1". I'll do some more research on BLOBS.

We defined a file/table within Lansa that contains an HTML field. The file/field is being used to store free-format notes entered within our Lansa application. I now have to figure out how to output to this field using an RPGLE program on the iseries as well.

Does anyone have any experience doing ...

I figured out the answer. Drop Downs for fields on a dialog box are loaded when the Method routine containing the call to the Dialog box is initiated.
In my case, simply moving the "Get_Entry" into the ItemClick Event routine, allowed me to get the value I needed, then when the ShowCurrentItem ...

I have a VIEW (#PRIM_VIEW) that displays a list of "Jobs". When the user selects one of the Jobs from the list, a DIALOG (#PRIM_DLG) appears, displaying data and allowing maintenance of the record chosen. The dialog contains multiple fields that are drop downs (dynamic picklists). I'm debugging the ...

LANSA support confirmed that the DateTimeField calendar functioned for them as it did for me.
They said that this design was intentional (maybe to act as a means to jump forward/backward one month at a time), however, after thinking about it some more they thought it made more sense to close the ...

Thanks for confirming. I just submitted an incident on the Support Portal. We'll see what they say.

I have a DateTimeField in my Dialog (#PRIM_DLG).

When the user selects a date for the month shown in upper left (e.g. July), the date value changes and the calendar is automatically closed. However, if the user chooses a date in the prior or subsequent month (June or August: those shown in yellow ...

I'm wondering if I will need to do something similar for my issue.

I am attempting to display a data field from a SQL database that is stored as Datetime2. The time is stored in that database as our literal local time (not UTC). For example - 2018-11-12 14:56:00.0000000.

Within Lansa, I have ...

The easiest change for me to make was to add the one line of code to each command handler to pass the Framework info to the reusable part that they all shared.

#OC_RP_Command_OppHeader.avFrameworkManager <= #avFrameworkManager

From within the one reusable part containing my header info and button ...

The command Handler in question is named "OC_RP_Command_Sales" . It (along with several other command handlers) references my reusable part, named "OC_RP_Command_OppHeader" , that contains the header fields. I included another screen shot below.

Command Handler "OC_RP_Command_Sales"
Begin_Com ...