Visual LANSA Forum

Hi Greg,

I try to use your quick test code, but it seems the problem is still there. The first number, which is '3' is missing.

before:

after:

No one know the solution??

Hi all,

I have encounter some weird result from using 'round' function.

I have a calculation which will result a set of number with 2 decimal point. I want to remove the decimal point and round up the value. If I round up to one decimal point, the result will come out okay. but if I round up to 0 ...

Hi All,

Recently, I have been trying to use select_sql free format to run a SQL query. It is working well and the data is display to the web but I have 2 problem.

1)The edit mask that I assign to the field is not working and the result will have leading zero.
2)It will add one more entry at the ...

Hi Joe,

Thanks for the help last week.

I have manage to past a LIST data to the second RP, but the thing is, its only display the last entry of my list to the RP. How can I loop the RP based on the entry on my list and display the data accordingly.

This is the result that i got:
filter.PNG ...

Hi there,

wp1.PNG

As you can see in above picture, I create 2 RP. 1 is Filter RP & 2 is to display the filtered result. When the user click the button(‘JANA’), it will call a method in Application Controller RP (code below).

Mthroutine Name(SelectState)

Define_Map For(*input) Class(#prim ...

Does anyone have an example how to generate the md5?? even the simple one will help. Please

Hi there,

I have a few question referring to below picture:

VLFONE.PNG

1) Dynamic dropdown/picklist
- How can I make the 'CAWANGAN' value appear depends on the 'NEGERI' selection?

2) How do I make the horizontal scroll for the instances list? As you can see the column is crowded.

3) 3) Why ...

Hi Mark,

I want to achieve something like picture below.

I want to have a filter with 4 user input (the picture only show 3):
1) Date
2) State
3) Branch
4) Product

If the user choose date only, so the first sql will run and show all the state, branch and product.
if the user select date and a ...

Hi all,

Ive been trying to use vfl one filter with four user input. If there has only one field, using generated code from program coding assistant, it works fine. but when im trying to add other field, it just read the first field and display the filter result based on the first field only not ...

MarkD wrote:Sorry, I don't know the answer to that for sure.
I would think the answer is no, but writing and running a program like this should solve that.

select *all from_file(OTHER)
insert fields(*all) to_File(YOURCOPY)
endselect

and where should i run this script?

My understanding is that files (tables) are either defined and maintained by LANSA, or they are defined and maintained by some other external tool - this is called an OTHER file.

You can’t change an OTHER file in LANSA.

To change an OTHER file, alter it using the external tool, then reload the ...

Hi there,

I have load existing tables from my db with option 'load other file' into lansa. It compiled perfectly. but it seems i cant add new logical views to the file i recently added. I need that logical view to make a filter in VLF One. Please Help

Does anyone know how to integrate google font into RP? Based on example 'xDemoWebGoogleFonts' IDE will have a tab call integration to use the google fonts into the webpage. But in RP, I dont see the tab call 'integration'. So i wonder how can i manage to do that.

sorry i have delete the logon i made. basically the output is same like above but it show error :
1) Please check your server logs (I dont know where is the server log stored)
2) Call to user IIP failed.

UF_OLOGON is not involved in logging on as designer - I just wanted to know what version of the VLF you are using.

You should look for the X_ERR.LOG (and maybe QPJOBLOG spool files if using an IBM i server) as suggested in the other posts.

One of them should have detailed error messages that tell ...

MarkD wrote:What type of web server are you using? Windows or IBM i?

Im just running it in my localhost windows.

Could you start the shipped VLF-ONE demo framework as designer and get the build number and date?
Click the About button and scroll to the end:


The About is working perfectly fine. This is the detail (I cant attach the picture, dont know why):
VL Framework Build Number : 141006
VL Framework ...

Hi all,

I try to do VLF-ONE login page that use my own db/lansa file but end up getting the error as follows:

1) Please check your server logs (I dont know where is the server log stored)
2) Call to user IIP failed.

Can anyone help me on this. If anyone get an example the edited UF_OLOGON would ...

hi,

for me, creating files and reading/writing records in a file was one of the first things I learned doing Lansa.

ask your boss for some sort of basic Lansa course, if they won't do it, just follow some of the education links from the home page and do some of the examples. I found this onea ...