Search found 52 matches

by Jiri
Fri Sep 19, 2025 5:44 pm
Forum: Questions & Answers
Topic: Convert LANSA RDML/RDMLX into text files
Replies: 1
Views: 17022

Convert LANSA RDML/RDMLX into text files

Hello,
We have requirement to export LANSA RDML/RDMLX code into text form, in aim to use it as input for code analyse using AI engine.
For first look, it should be quite simple, using LANSA APIs (in form of Repository Related BIFs). I supposed, I will use for working with processes/functions GET ...
by Jiri
Tue Apr 15, 2025 12:15 am
Forum: Questions & Answers
Topic: How to add Tab (ASCII hex09) character into string data ?
Replies: 2
Views: 29986

Re: How to add Tab (ASCII hex09) character into string data ?

Thanks, works fine. Unfortunately, this a very simple solution is not clear in Intrinsic functions topisc.
by Jiri
Sat Apr 12, 2025 12:11 am
Forum: Questions & Answers
Topic: How to add Tab (ASCII hex09) character into string data ?
Replies: 2
Views: 29986

How to add Tab (ASCII hex09) character into string data ?

Maybe simple question:
- I need to programatically add some special characters into string, filled in LANSA RDMLX logic. For example, a tab delimiter, which is hex 09 in ASCII. It can be probably use some conversion intrinsic function, but the description of intrinsic functions is not very clear ...
by Jiri
Fri Nov 29, 2024 3:02 am
Forum: Questions & Answers
Topic: VisualLANSA Windows client IP Address
Replies: 5
Views: 62558

Re: VisualLANSA Windows client IP Address

With this great support we got working it finally. We modified the powershell script to be abble get all IPV4 addresses, if the workstation have more (my NTB about six due to VPNs etc). We also modified some other details to be safe. The example form code is bellow, if you need the logic, all is ...
by Jiri
Wed Nov 27, 2024 1:53 am
Forum: Questions & Answers
Topic: VisualLANSA Windows client IP Address
Replies: 5
Views: 62558

Re: VisualLANSA Windows client IP Address

In VL-WEB it is not problem, and Web client has only one address. But Windows client can have more IP Addresses and *WEBIPADDR does not work in native Windows (not web) client.
by Jiri
Wed Nov 27, 2024 1:03 am
Forum: Questions & Answers
Topic: VisualLANSA Windows client IP Address
Replies: 5
Views: 62558

VisualLANSA Windows client IP Address

I would need to get IPV4 IP address of PC, where VL windows client runs. Or list of active addresses (one station can have more IP addresses, i.e in case of using VPN). Could you advice me a simple way, how to get it in VL application?
by Jiri
Tue Oct 22, 2024 12:10 am
Forum: Questions & Answers
Topic: Import data from xls xlsx
Replies: 3
Views: 23225

Re: Import data from xls xlsx

XLS are supported? I suppose only A / B /C /D /O /T formats (or variants with unicode) are supported.
In fact D (DBF) is obsolete and XLS or XLSX would be much better, but I have no information about XLS format support in BIFs.
Of course, Integrator supports it a long time.
by Jiri
Fri Jan 24, 2020 12:05 am
Forum: Questions & Answers
Topic: Integrator SQL Service SP procedure call- JSON parameter format?
Replies: 0
Views: 41833

Integrator SQL Service SP procedure call- JSON parameter format?

MS/SQL Server version 2016 allows to pass parameters in JSON format. Is possible to use this from LANSA via Integrator?

If 'standard' parameter is used, the SQL syntaxe is for example:

Exec ptc.delene_provize '1234567890'

In LANSA, following code is used:
DEF_LIST NAME(#INP_LIST) FIELDS ...
by Jiri
Fri Nov 01, 2019 3:22 am
Forum: Questions & Answers
Topic: Adjust a date by month
Replies: 5
Views: 16311

Re: Adjust a date by month

Those are good and fully working examples, but we would prefer an enhancement that LANSA would support standard date operations like many other languages. The syntax may be LANSA specific, but it should be possible to use months /years in adjustment directly, not via mathematic operation followed by ...
by Jiri
Thu Jul 04, 2019 11:26 pm
Forum: Questions & Answers
Topic: 'Clickable' field item in ListView (Windows interface)
Replies: 0
Views: 32065

'Clickable' field item in ListView (Windows interface)

We have requuest for following functionality:
In Windows listview should be one column used for marking specific rows. The 'marked' rows wil contain some image here (i.e. asterix), another rows none (*null image).
It should be changed by single click limited to the specified column. It means, no ...
by Jiri
Wed Mar 14, 2018 1:54 am
Forum: Questions & Answers
Topic: C code for virtual field derivation - example ?
Replies: 2
Views: 11472

Re: C code for virtual field derivation - example ?

Yes Stewart, I know it and I am using it on new projects.
But the affected files must stay RDML , because they are read by many RDML functions, which cannot be converted to RDMLX due to 5250 screens or report commands not alloved in RDMLX. And vice versa - RDMLX file cannot be directly read from ...
by Jiri
Tue Mar 13, 2018 12:36 am
Forum: Questions & Answers
Topic: C code for virtual field derivation - example ?
Replies: 2
Views: 11472

C code for virtual field derivation - example ?

Our customer is considering partition change from RDML->RDMLX. This is recommended by LANSA, and it is requirement for usage of many LANSA features.

There is problem with couple of files, which are using RPG code for virtual field derivation. For RDMLX, another C based OAM is created, not using ...
by Jiri
Fri Jun 09, 2017 10:08 pm
Forum: Tips and Techniques
Topic: JSON external data transfer
Replies: 10
Views: 41289

Re: JSON external data transfer

Anyone have an example, how to pass basic authentication (User & Password) to LANSA HTTP request header?
On web, there is lot of examples for PHP, Nette etc. but we are not able to implement it il LANSA.
If the authorisation data (User and Password) are not passed by browser, browser will ask for ...
by Jiri
Sat Apr 22, 2017 12:39 am
Forum: Tips and Techniques
Topic: MS/SQLEXPRESS installation in Deployment
Replies: 0
Views: 20726

MS/SQLEXPRESS installation in Deployment

Hello,
We are creating a very simple demo application, which should be (as typicall demo) installed localy on single computer (small database as well as VL windows compoments).
The aim is to made installation (and possible uninstallation) as easy as possible for demo users. In example (if possible ...
by Jiri
Wed Apr 12, 2017 6:54 pm
Forum: Questions & Answers
Topic: Login PopUp - how to allow remembering login values ?
Replies: 5
Views: 13870

Re: Login PopUp - how to allow remembering login values ?

Thanks Steward, it is good and simple example
by Jiri
Wed Apr 12, 2017 6:44 pm
Forum: Questions & Answers
Topic: Theme for required button style
Replies: 3
Views: 8656

Theme for required button style

Hello,
We have request for button style behaviour:
Inactive (dissabled) buttons should have fill color grey
Enabled buttons should fill red. All others states (i.e. focused, mouseover etc.) are identified by text style change and cursor for mouseover, the fill reminds red.
The problem is, in Theme ...
by Jiri
Wed Apr 12, 2017 1:16 am
Forum: Questions & Answers
Topic: How to delete large number RDMLXfunctions from production environment
Replies: 2
Views: 5976

Re: How to delete large number RDMLXfunctions from production environment

Did you tried to use Repository Built-in functions? We are using it for similar tasks.
See:
http://docs.lansa.com/14/EN/lansa015/in ... 1_0036.htm
by Jiri
Wed Apr 12, 2017 1:13 am
Forum: Questions & Answers
Topic: Login PopUp - how to allow remembering login values ?
Replies: 5
Views: 13870

Re: Login PopUp - how to allow remembering login values ?

Does not work for me :-(

Can you provide any functional example ? Either the login as requested or a possibility to store login localy?
by Jiri
Mon Apr 10, 2017 8:54 pm
Forum: Questions & Answers
Topic: Login PopUp - how to allow remembering login values ?
Replies: 5
Views: 13870

Login PopUp - how to allow remembering login values ?

VL-web application uses a simple login POP-UP window for entering required User name and Password .
The authentication logic in using application file (containing profiles and encrypted passwords) and server module for authentication.
It works fine, but customer is wondering, why this login cannot ...
by Jiri
Sat Apr 01, 2017 1:46 am
Forum: Tips and Techniques
Topic: VLF Windows - Send to MS Excel example
Replies: 6
Views: 29447

Re: VLF Windows - Send to MS Excel example

The stream file management is not problem - if we cannot use your internal BIF, we can create own (or reusable component) for it to allow share the logic for more instance lists on single place.
But for real implementation, and in aim to ensure similar behaviour for built-in Instance lists as well ...