Visual LANSA Forum

Hi Dino,

1) Regarding this:
If everything were in the same partition the desktop application will know the files and fields and they will be located in the correct default library list, so all will be seamless
I tried creating a table in the same partition and I can access the table when I ...

Hi Arlyn,

Thanks for your reply.

I tried following your steps but it did not do the trick for me unfortunately.

I will do some more digging.

Romain

Hello,

I am trying to learn how to create a desktop application and I am working in a different partition than the one I used for developing my web applications. I am having trouble accessing tables that I have defined in the "web" partition. I tried 2 different ways:

1) Using select_sql to try ...

Yes I have tried using 'Binary' but unfortunately it does not seem to work.

Thanks anyway

Hi Christophe,

Thank you for your response, I tried using your method and it works!

However, we did some testing with the BIF transform list and we realized that if we converted our csv file to UTF-8 BOM (using Notepad++), the characters were read correctly so that is why we wanted to try to add ...

Hello everyone,

I am trying to create and send a csv file by email. However, in the output csv file, I am having trouble reading special characters such as "è", "à", "ù" or "ç".

My original idea was to use the built-in function Transform list like this:


#FilePathMat := '/LANSA_ptdpgmlib/tmp ...

After asking LANSA Support, we have found the solution to our issue.

Here is what they said:
Problem determination:

The call LANSA is making only support strict SNI. So if the FQDN doesn't match or the SNI doesn't send an acknowledgement, the secure connection will fail (page 110 of document ...

Hello everyone,

I’m facing a similar issue with making HTTPS requests from Visual LANSA on an IBM i system. I am using the LANSA Server as the "Client".

I’m using the #Request.DoGet (#Request is a #XPRIM_HttpRequest component) command in my Srvroutine to call an HTTPS endpoint.
The command works ...

Hi Arlyn,

Thanks for your response. I actually found a simpler solution for me to loop in the array:
Thanks,

Romain

Hi,

I am working on a POST request for an API and in the body of my request I have a JSON object. In this JSON object I have 3 elements, two being fields and one being an array. Example:
{
"NaceArray": ["41","42","43","71"],
"CODLAN": "1",
"NBRMAX": 0
}

In the API source code, if I want to ...

Hi,

I am having issues while uploading very large csv files (around 860MB) using a filepicker component in my web application.

I have done some digging and it seems that when I upload a file, it copies it to a folder in ...\ptdpgmlib\run\web_upload and then deletes it and copies it to the TMP ...

Hi Brendan,

I have tried using the keypress event but for some reason the event is not fired when I press the control or shift keys. It is fired when I press other keys though.

Below is part of my code:

Define_Com Class(#PRIM_LIST) Name(#Categories) Parent(#COM_OWNER) Displayposition(4 ...

Hello,

I am looking for a way to check if a key is pressed inside an eventroutine and I have found the PRIM_KBRD component class which provides access to the Shift, Alt and Ctrl key states. However, when I try to define it in a view component, I have this error: "Component class PRIM_KBRD is ...

Brendan,

Thank you very much for your help, it was very helpful! Everything works perfectly now

After further investigation, the issue comes from the file being uploaded to a tmp folder in the IFS and when I submit my function I don't have access to the file anymore (maybe because the srvroutine ended before the end of my function?).

Is there a way to prevent this?

Or is there maybe a way ...

Unfortunately you have run into a BROWSER TIMEOUT...

to put it simply, most browsers will 'timeout' a request after 5 minutes of no response. (i think Safari might be 6 minutes, but the rest are 5 minutes).

a better way might simply to be:

have your server routine:

1. receive the file from the ...