Search found 59 matches

by René Houba
Thu Aug 15, 2019 5:16 pm
Forum: Questions & Answers
Topic: Sorting PRIM_LCOL (RESOLVED)
Replies: 7
Views: 218

Sorting PRIM_LCOL

I have an old example available related to PRIM_LCOL. Please let me know if you are interested.
by René Houba
Tue Aug 13, 2019 11:55 pm
Forum: Questions & Answers
Topic: Email protocol IMAP and LANSA Integrator
Replies: 0
Views: 77

Email protocol IMAP and LANSA Integrator

Hi,

One of our customers is using the email protocol IMAP instead of POP3.

Using LANSA Integrator, I do not see how to use this protocol.
Do I miss something or is this protocol not supported by LANSA Integrator yet.


Kind regards,
René
by René Houba
Wed Jul 17, 2019 5:00 pm
Forum: Tips and Techniques
Topic: LANSA Technical Newsletter July 2019
Replies: 0
Views: 83

LANSA Technical Newsletter July 2019

Here is the link to the July 2019 LANSA Technical Newsletter: https://www.lansa.com/downloads/support/newsletter/blx_newsljul19.pdf Topics discussed include: - New License Model LANSA - LANSA License Server Install error - Composer 7 - LANSA V13 SP2 and OpenJDK - aXes version 4.2.0 - LANSA Roadmap T...
by René Houba
Fri Jun 28, 2019 6:18 pm
Forum: Questions & Answers
Topic: SQL Join
Replies: 9
Views: 416

Re: SQL Join

Hi Art,

We use this technique in some VLF projects where we have a very complex filled Instance List. Because the selection in done already by the VIEW, this instance list is filled very quick.
by René Houba
Fri Jun 28, 2019 7:20 am
Forum: Questions & Answers
Topic: SQL Join
Replies: 9
Views: 416

SQL Join

Another technique is to create a view on your iSeries. Example: Create View VWWOPS1 AS( select VBSWOP.WOPCDE, VBSWOP.STSCDE, VBSWOP.GBRODG,VBSWOP.BWSCDE , VBSWOP.MCDCDE, VBSWOP.ORDCDE, VBSWOP.WOPDAT, VBSWOP.WOPRD1, VBSWOP.WOPOP1, VBSWOP.NOTCDE, VBSVRD.ARTCDE, VBSVRD.GENCDE, VBSVRD.BSTCDE, VBSVRD.PAR...
by René Houba
Thu Jun 06, 2019 4:44 pm
Forum: Questions & Answers
Topic: visualstyle in grid ?
Replies: 2
Views: 460

Re: visualstyle in grid ?

This is also possible Paul:

If_ref com(#grid1.CurrentItem.cell<5>.VisualStyle) is(*instance_of #spvs0020)
by René Houba
Wed May 08, 2019 4:43 pm
Forum: Questions & Answers
Topic: Request
Replies: 2
Views: 8476

Re: Request

Good idea :-)!
by René Houba
Tue May 07, 2019 4:40 am
Forum: Questions & Answers
Topic: LANSA Open message LCE0023
Replies: 5
Views: 20646

Re: LANSA Open message LCE0023

This problem is solved and was related to a setting in their firewall.
by René Houba
Wed May 01, 2019 9:07 pm
Forum: Questions & Answers
Topic: LANSA Open message LCE0023
Replies: 5
Views: 20646

Re: LANSA Open message LCE0023

So you have an existing environment without any problems. In your new citrix-environment (Citrix Xen desktop 7.17089) on a Windows 2016 server (alle patches applied) and a SQL 2017 database, you have this problem: after an hour of inactivity, the Delphi/LANSA Open program returns with an LCE0023. If...
by René Houba
Wed May 01, 2019 5:09 pm
Forum: Questions & Answers
Topic: LANSA Open message LCE0023
Replies: 5
Views: 20646

Re: LANSA Open message LCE0023

Do you have this problem suddenly?
Or is this a new Citrix environment on a new Windows 2016 server and you have this problem since you run the LANSA Open programs in this new environment?

Kind regards,
René
by René Houba
Tue Apr 30, 2019 4:51 am
Forum: Questions & Answers
Topic: New To Visual Lansa
Replies: 13
Views: 11096

Re: New To Visual Lansa

Hi, where are you from?

Kind regards,
René
by René Houba
Thu Apr 04, 2019 5:33 am
Forum: Questions & Answers
Topic: Make image sizes smaller (Composer)
Replies: 1
Views: 4328

Make image sizes smaller (Composer)

Hi, One of our customers receives from their customers xml data with binary data (containing pictures). The problem is that the size of the pictures are sometimes very big (not too big to receive). So if a pictues size is too big after they have received it and stored in a servers directory, they wa...
by René Houba
Mon Mar 18, 2019 7:53 am
Forum: Questions & Answers
Topic: Disable Autofill function in Browser
Replies: 6
Views: 3319

Re: Disable Autofill function in Browser

Hi Dominique, This is a browser setting, isn't it?? For Chrome for example: Turning Off Autofill in Chrome Click the Chrome menu icon. (Three dots at top right of screen.) Click on Settings. In the "Autofill" section, expand the area for which you wish to disable Autofill. Toggle the setting OFF if ...
by René Houba
Wed Feb 13, 2019 9:54 am
Forum: Questions & Answers
Topic: Set Focus to Cell in Grid
Replies: 2
Views: 1785

Re: Set Focus to Cell in Grid

Hi Lawingo,

After:
Set Com(#GridColumn6.Cell<1>.Column) Focus(True) Selected(True) Ensurevisible(True)

Do:
GridMain.SetFocus

Does that help?

Kind regards,
René
by René Houba
Wed Feb 06, 2019 7:02 pm
Forum: Questions & Answers
Topic: Recursive call of OAM
Replies: 7
Views: 2382

Re: Recursive call of OAM

Hi Priya,

Can you show the RDML part?

Kind regards,
René
by René Houba
Tue Feb 05, 2019 11:44 pm
Forum: Questions & Answers
Topic: Recursive call of OAM
Replies: 7
Views: 2382

Re: Recursive call of OAM

Hi Priya,

When does the crash occur?
When you run the program?

Is there a trigger function involved for this file for example where you use the same file?


Kind regards,
René
by René Houba
Tue Feb 05, 2019 11:34 pm
Forum: Questions & Answers
Topic: LANSA Integrator - How to pass large base64 value
Replies: 9
Views: 4432

Re: LANSA Integrator - How to pass large base64 value

Hi Nick,

You could be rigth about that. I will check.

In the meantime, this visual LANSA forum contains something for enhancement request:
Suggestions for Product Enhancements

Please put this as an enhancement in there!


Kind regards,
René
by René Houba
Tue Feb 05, 2019 11:20 pm
Forum: Questions & Answers
Topic: LANSA Integrator - How to pass large base64 value
Replies: 9
Views: 4432

Re: LANSA Integrator - How to pass large base64 value

Hi Nick,

Integrator support a data type binary based 64 file:
Data Type binary based64 file (1).JPG
Data Type binary based64 file (1).JPG (63.77 KiB) Viewed 2493 times
Data Type binary based64 file (2).JPG
Data Type binary based64 file (2).JPG (25.25 KiB) Viewed 2493 times
by René Houba
Tue Jan 29, 2019 7:39 am
Forum: Tips and Techniques
Topic: LANSA Technical Newsletter January 2019
Replies: 0
Views: 12973

LANSA Technical Newsletter January 2019

Here is the link to the January 2019 LANSA Technical Newsletter: https://www.lansa.com/downloads/support/newsletter/blx_newsljan19.pdf Topics discussed include: - New VLF version - ActiveX crash in Visual LANSA editor - Troubleshooting common SQL Server errors and return codes - UPDATED: Java compli...
by René Houba
Thu Sep 20, 2018 9:06 pm
Forum: Questions & Answers
Topic: LANSA V14 SP1 with OS/400 V7R3M0 and Java V1.7.0
Replies: 3
Views: 1920

LANSA V14 SP1 with OS/400 V7R3M0 and Java V1.7.0

Hi, One of our customers upgraded their iSeries OS/400 last weekend to V7R3M0 and they use Java V1.7.0 with that. Since the upgrade the Integrator JVM jobs on the iSeries seems to hang with status SELW: Integrator problems iSeries.JPG Now, no Integrator jobs can be activated. Does anyone know if the...