Search found 30 matches

by billcross
Sat May 13, 2017 4:05 am
Forum: Questions & Answers
Topic: Using WHERE with FETCH
Replies: 2
Views: 1094

Re: Using WHERE with FETCH

Because the field names you want to compare are the same, I believe the only way to do it is to store the first files WLCKCN in another field (#TWLCKCN) and then change the where in the fetch to where('#WLCKCN = #TWLCKCN').
by billcross
Fri May 05, 2017 5:12 am
Forum: Questions & Answers
Topic: IBM i LANSA Disaster Recovery
Replies: 5
Views: 1905

Re: IBM i LANSA Disaster Recovery

That would work as long as the new license was applied post mirroring. I would also recommend that you verify with Lansa other places where license information may be stored.
by billcross
Fri May 05, 2017 4:56 am
Forum: Questions & Answers
Topic: IBM i LANSA Disaster Recovery
Replies: 5
Views: 1905

Re: IBM i LANSA Disaster Recovery

Unfortunately is isn't that easy. The Lansa license information that is stored on the IFS uses the serial number of the machine in question. Running Lansa on the mirrored system with the mirrored IFS will generate a license error.
by billcross
Thu Apr 27, 2017 3:22 am
Forum: Questions & Answers
Topic: REPLACE in SELECT_SQL Where
Replies: 10
Views: 2766

Re: REPLACE in SELECT_SQL Where

Have you tried putting the where into a variable and using the *QUOTE field instead of ' ? The command to build could be

#WHERE := <Start of Where> + *QUOTE + ' ' + *QUOTE + ',' + *QUOTE + *QUOTE + <End of Where>
by billcross
Wed Apr 19, 2017 1:05 am
Forum: Questions & Answers
Topic: Exchange from form to function and back
Replies: 8
Views: 1962

Re: Exchange from form to function and back

Are there a lot of fields in the function itself ? I have encountered an issue where a function with the total length of all fields is > 10000 that it causes and index error when trying to read the exchange list. All fields are in the exchange list whether exchanged or not and the index is only a 4 ...
by billcross
Sat Mar 25, 2017 3:57 am
Forum: Questions & Answers
Topic: Maximum Number of Virtual Fields
Replies: 1
Views: 865

Re: Maximum Number of Virtual Fields

I don't know if there's a maximum but 24 isn't it. We have created many more than that with no issues.
by billcross
Fri Mar 24, 2017 12:27 am
Forum: Questions & Answers
Topic: Read only radio button
Replies: 2
Views: 1173

Re: Read only radio button

I have done that but I still think that setting ReadOnly property to True should make the radio button unchangeable.
by billcross
Thu Mar 23, 2017 11:13 pm
Forum: Questions & Answers
Topic: Read only radio button
Replies: 2
Views: 1173

Read only radio button

I have set the readonly property of a radio button, but it does not seem to prevent clicking on the field and changing it's value, is this a bug ?
by billcross
Wed Mar 22, 2017 9:23 pm
Forum: Questions & Answers
Topic: Stop executing code in an event handler
Replies: 1
Views: 815

Stop executing code in an event handler

Is there a way to stop executing the code in an event handler before it is completed ? In a subroutine you can simply do a return but there is nothing for an event handler to return to.
by billcross
Thu Mar 09, 2017 5:49 am
Forum: Questions & Answers
Topic: Keep Leading Zeros
Replies: 2
Views: 943

Re: Keep Leading Zeros

If you place a 0 in the tenth position of your edit word that might do it. The zero represents the last position that zero suppression is to stop so by putting it in position 10 of a 9 digit field all leading zeros should show.
by billcross
Mon Sep 19, 2016 7:52 pm
Forum: Questions & Answers
Topic: Server modules
Replies: 15
Views: 8490

Re: Server modules

A simple sample would help a lot.
by billcross
Sat Sep 17, 2016 12:28 am
Forum: Questions & Answers
Topic: Server modules
Replies: 15
Views: 8490

Re: Server modules

How do you pass the URL of the new page into StartMyPage ?
by billcross
Wed Aug 17, 2016 8:03 pm
Forum: Questions & Answers
Topic: Server modules
Replies: 15
Views: 8490

Re: Server modules

Persistents works from reusable part to reusable part but does not appear to work from web page to web page which was what I meant to ask in my previous question instead of window.

Do persistent fields and lists stay available when you change from one web page to another one ?
by billcross
Tue Aug 16, 2016 8:49 pm
Forum: Questions & Answers
Topic: Server modules
Replies: 15
Views: 8490

Re: Server modules

Do persistent fields and lists stay available when you change from one window to another one ?
by billcross
Tue Aug 09, 2016 10:18 pm
Forum: Questions & Answers
Topic: Server modules
Replies: 15
Views: 8490

Server modules

Are server modules that are defined in reusable parts loaded once or are they reloaded each time the specific module is executed ?

If they are reloaded is there a way to keep them resident while the reusable part is open ?
by billcross
Thu Jul 28, 2016 9:37 pm
Forum: Questions & Answers
Topic: Image in a Carousel
Replies: 3
Views: 1428

Re: Image in a Carousel

So does that mean that a JPG is not being converted to a BMP when the filename for a PRIM_BMP is set to a JPG file ?
by billcross
Thu Jul 28, 2016 12:41 am
Forum: Questions & Answers
Topic: Image in a Carousel
Replies: 3
Views: 1428

Image in a Carousel

In the carousel examples the image used is a bitmap, is this the only image type that can be used and if not how do you make the carousel use a different type ?
by billcross
Thu Jul 28, 2016 12:38 am
Forum: Questions & Answers
Topic: Refresh Main Page
Replies: 1
Views: 935

Refresh Main Page

I have an application that is one web page with multiple panels that are displayed when selected by the user navigating through the app. When the app is transitioning from panel to panel I am setting the web page caption to indicate that the transition is occurring (some panels take a few seconds to...
by billcross
Thu Jul 07, 2016 1:30 am
Forum: Questions & Answers
Topic: Click Event in a Carousel
Replies: 8
Views: 2889

Re: Click Event in a Carousel

This now works but I'm having an issue properly detecting the transition from one item of the carousel to the next. I thought ItemGotFocus would be the event to use but it does not seem to fire when the carousel item is changed. What event should be used ?
by billcross
Wed Jul 06, 2016 8:16 pm
Forum: Questions & Answers
Topic: Splash Screen Differences
Replies: 1
Views: 1094

Splash Screen Differences

I am using the xDemoWebSplashScreenPopup to display a splash screen to indicate that a search is running. I am testing in Firefox, IE 11 and Google Chrome with the following results. Firefox - Works as expected, opens before the search and closes when it completes. IE 11 - No splash screen appears. ...