Search found 689 matches

by jyoung
Wed Sep 02, 2020 1:01 am
Forum: Questions & Answers
Topic: Change background color of grid header / listview header
Replies: 2
Views: 379

Re: Change background color of grid header / listview header

For VLWEB and the PRIM_LIST control, you can set the ColumnStyle on the list. begin_com role(*EXTENDS #PRIM_WEB) LayoutManager(#Layout1) define_com class(#PRIM_VS.Style) name(#Style1) BackgroundBrush(#Brush1) define_com class(#PRIM_VS.SolidBrush) name(#Brush1) Color(0:150:136) define_com class(#PRIM...
by jyoung
Thu Aug 27, 2020 5:10 am
Forum: Questions & Answers
Topic: Integrator - Copy a template sheet to create a new sheet on ExcelService
Replies: 3
Views: 431

Re: Integrator - Copy a template sheet to create a new sheet on ExcelService

Hi Megumi, I think it depends on what type of template you are using. I don't think formulas and things like that work, but you can have a template and use that as a starting point. That is how we handle a couple different reports. For example, I have three templates defined in a "templates" folder ...
by jyoung
Fri Jul 17, 2020 1:57 am
Forum: Questions & Answers
Topic: RESTful on IBM i
Replies: 17
Views: 1583

Re: RESTful on IBM i

LOL, I can't tell you how many rabbit holes I have been down only to find out there was a port that was not open.

Glad you got it worked out.

Joe
by jyoung
Wed Jul 15, 2020 11:48 pm
Forum: Questions & Answers
Topic: RESTful on IBM i
Replies: 17
Views: 1583

Re: RESTful on IBM i

Hey Jim, Have you been able to access the xvlwebtst.html from your server? For example, localhost:{port}/{pgmlib}/{partition}/xvlwebtst.html you should get blue LANSA box that states the web server is running. If that works, then try out of localhost such as tstnesaapi:{port}/{pgmlib}/{partition}/xv...
by jyoung
Tue Jul 14, 2020 11:20 pm
Forum: Questions & Answers
Topic: VL-Web: Active Directory authentication with ServerModule
Replies: 2
Views: 389

Re: VL-Web: Active Directory authentication with ServerModule

I don't know if you can do it directly from a Server Module, but you can using Integrator. Its how we do it at least. Look into the OpenLDAPService. https://docs.lansa.com/14/en/lansa093/index.htm#lansa/intengb7_3640.htm We wrap this type of stuff up in a LDAP Process with LDAP Functions which makes...
by jyoung
Fri Jul 10, 2020 11:38 pm
Forum: Questions & Answers
Topic: RESTful on IBM i
Replies: 17
Views: 1583

Re: RESTful on IBM i

Hey Jim, You won't access the url from on the iSeries. You access the url from the Windows Proxy, which will call the corresponding ServerModule on the iSeries. On your Windows Server, IIS will be installed and should be handling all the requests. The LANSA install on the Windows Server will install...
by jyoung
Thu Jul 09, 2020 11:45 pm
Forum: Questions & Answers
Topic: RESTful on IBM i
Replies: 17
Views: 1583

Re: RESTful on IBM i

We have a REST API in production on the IBM i, but as others have mentioned, you must have a Windows IIS server in front of it. Interestingly, you don't actually do anything with it once you get the LANSA bits on it, it just proxies the request through. One word of caution I would tell anyone who is...
by jyoung
Thu Jul 09, 2020 2:23 am
Forum: Questions & Answers
Topic: Integrator - OpenLDAP - Password with special characters
Replies: 2
Views: 660

Re: Integrator - OpenLDAP - Password with special characters

Brendan,

I can't tell you how long I spent looking at that trying to figure out how to do this.
For whatever reason, I never thought I could just wrap it double quotes. :roll:

That was exactly what I needed. lol

Thanks for replying.
Joe
by jyoung
Tue Jul 07, 2020 11:30 pm
Forum: Questions & Answers
Topic: Integrator - OpenLDAP - Password with special characters
Replies: 2
Views: 660

Integrator - OpenLDAP - Password with special characters

We use Integrator's OpenLDAP to authenticate users with Active Directory. For the most part this works great, but we are running into an issue with users that have passwords with special characters like a parentheses. The character in the password seems to blowing up the command. The auth code looks...
by jyoung
Sat Jun 27, 2020 4:45 am
Forum: Questions & Answers
Topic: Task Tracking - Revert Local Changes
Replies: 4
Views: 516

Re: Task Tracking - Revert Local Changes

Yeah I saw that it was still associated with the Task which in this case is ok.
I just needed to dump these changes and start over. :shock:

I've not been doing much LANSA work in the past few months, so I am a bit rusty on all the small particulars.

Thanks for the reminder!
by jyoung
Sat Jun 27, 2020 3:27 am
Forum: Questions & Answers
Topic: Task Tracking - Revert Local Changes
Replies: 4
Views: 516

Re: Task Tracking - Revert Local Changes

The unlock was the piece I was missing.

Thanks!
by jyoung
Sat Jun 27, 2020 1:28 am
Forum: Questions & Answers
Topic: Task Tracking - Revert Local Changes
Replies: 4
Views: 516

Task Tracking - Revert Local Changes

I have a Server Module and some other Reusable Parts that are checked out with Task Tracking. They have changes that have not been checked in. I would like to revert all my local changes with the copy that is on the server, essentially removing all my changes. A "refresh" does not seem to be doing a...
by jyoung
Thu Jun 11, 2020 11:39 pm
Forum: Questions & Answers
Topic: Date Control value is previous day
Replies: 5
Views: 523

Re: Date Control value is previous day

I had the same issue some time ago and I raised an issue with support, this was before the Idera acquisition and the move to the new support system, however I think the solution was to use the STD_DATEX field instead of the PRIM_MD.DateTime. I forget the exact details as to why, but it was something...
by jyoung
Wed Jun 03, 2020 4:56 am
Forum: Questions & Answers
Topic: Add Boolean Field with Default True to LANSA File
Replies: 5
Views: 765

Re: Add Boolean Field with Default True to LANSA File

I can and will probably do that instead of trying to do some dynamic where clause. The issue is that this is in production and we have automated deployments so we will kick this off at night when no one is on the system. At which point I will have to log in from home and run the update script. Its m...
by jyoung
Wed Jun 03, 2020 2:59 am
Forum: Questions & Answers
Topic: Add Boolean Field with Default True to LANSA File
Replies: 5
Views: 765

Re: Add Boolean Field with Default True to LANSA File

That means setting the ASQN attribute which also means having to check for NULL or True for EVERY QUERY.

Ugh.

Was hoping to not have to do that, but it seems like the only way.

Thanks Art.
by jyoung
Tue Jun 02, 2020 3:34 am
Forum: Questions & Answers
Topic: Add Boolean Field with Default True to LANSA File
Replies: 5
Views: 765

Add Boolean Field with Default True to LANSA File

I have a LANSA built File that I am trying to add a Boolean field to with the default value of TRUE so that EVERY EXISTING RECORD in the File will be set to True. IsEnabled.PNG File.PNG However when I compile the Table with Rebuild / Drop and Load the Field is always (0) False. Table.PNG How do I ma...
by jyoung
Fri May 22, 2020 5:13 am
Forum: Questions & Answers
Topic: A Question about VL & Web Data Access
Replies: 3
Views: 792

Re: A Question about VL & Web Data Access

We do VLWeb and VLF-One only. Use a lot of Functions to share functionality across different things, but you cannot call them from VLWeb. So you end up having to have a Server Module to act as a "Proxy" and as Art mentioned you have to "exchange" them to the function. Took me a little bit to grok th...
by jyoung
Fri Apr 24, 2020 11:19 pm
Forum: Questions & Answers
Topic: VLWeb Completed Event for File Downloads
Replies: 2
Views: 1508

Re: VLWeb Completed Event for File Downloads

I tried doing the same with a a timer (instead of an event) where I show the loading image and start the timer on the button click and then on the timer tick, execute and hide the timer.

I never tried it with a blob, however. Will have to give that go.

Thanks,
Joe
by jyoung
Fri Apr 24, 2020 3:33 am
Forum: Questions & Answers
Topic: VLWeb Completed Event for File Downloads
Replies: 2
Views: 1508

VLWeb Completed Event for File Downloads

When downloading a file from a Server Module that uses the Response(*RESOURCE) parameter, is there any way to get a notification that download is completed? For example, here is a simple Server Module begin_com role(*EXTENDS #PRIM_SRVM) srvroutine name(DownloadCSV) response(*resource #Response) defi...
by jyoung
Tue Apr 21, 2020 1:46 am
Forum: Questions & Answers
Topic: Questions about Publish RESTful Web Services
Replies: 3
Views: 3059

Re: Questions about Publish RESTful Web Services

You may have to restart the subsystems. I have not tried this on the IBMi, only used it on my Windows dev box.

Joe