Search found 320 matches

by soa
Fri Sep 21, 2018 8:34 am
Forum: Questions & Answers
Topic: LANSA V14 SP1 with OS/400 V7R3M0 and Java V1.7.0
Replies: 3
Views: 2046

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

We have used this combination without issue for quite a while (and recently v14 SP2 & Java 8 as well).
by soa
Fri Sep 21, 2018 8:31 am
Forum: Questions & Answers
Topic: Searching all cells in a MD Datatable
Replies: 3
Views: 1032

Re: Searching all cells in a MD Datatable

Thanks.Great response i'll give that a go.
by soa
Thu Sep 20, 2018 4:50 pm
Forum: Questions & Answers
Topic: Searching all cells in a MD Datatable
Replies: 3
Views: 1032

Searching all cells in a MD Datatable

I want to search all cells in a material data table for a string with this sort of logic For each Row in List found = false for each Col in Row if item value contains 'Search string' found = true leave endif Row.Visible = found end for end for Can this be done? I can see a columns collection but not...
by soa
Mon Sep 10, 2018 3:24 pm
Forum: Questions & Answers
Topic: #XPRIM_HttpRequest & Base64
Replies: 2
Views: 1143

Re: #XPRIM_HttpRequest & Base64

Thanks for the prompt response Tony. I didn't know about the WriteBase64StringFromFile method.
by soa
Mon Sep 10, 2018 11:10 am
Forum: Questions & Answers
Topic: #XPRIM_HttpRequest & Base64
Replies: 2
Views: 1143

#XPRIM_HttpRequest & Base64

I am trying to send a file in a json object using the following code Define_Com Class(#XPRIM_Binary) Name(#MyFileBinary) #MyFileBinary.FromFile Path(#ifslnm) . . . #RootObject.InsertString Key('project') String(#MyFileBinary.AsBase64String) #Request.Content.AddJsonObject( #RootObject ) #Request.DoPO...
by soa
Tue Sep 04, 2018 10:48 am
Forum: Questions & Answers
Topic: Random Number Range
Replies: 2
Views: 1016

Re: Random Number Range

Good work Mark. Saved me a bit of messing round and achieves a god distribution over a 1000 calls.
by soa
Mon Sep 03, 2018 5:35 pm
Forum: Questions & Answers
Topic: Random Number Range
Replies: 2
Views: 1016

Random Number Range

LANSA's RAndnom_number_generator BIF returns a number between 0 and 1. Has anybody out got a neat trick to this this into a range, e.g. Integers between 1 and 15. I had an RPG based BIF that did this trick but it doesn't work in RDMLX.
by soa
Fri Aug 31, 2018 1:21 pm
Forum: Questions & Answers
Topic: Convert SQL to RDMLX?
Replies: 11
Views: 2218

Re: Convert SQL to RDMLX?

I agree that in an sql world i/o modules don't make as much sense as they did the rpg days. It should be possible to implement all the validation rules in the repository as native sql constraints and access routes as views etcetera and basically do away with i/o modules but I guess there's only so m...
by soa
Fri Aug 31, 2018 11:34 am
Forum: Questions & Answers
Topic: Convert SQL to RDMLX?
Replies: 11
Views: 2218

Re: Convert SQL to RDMLX?

What is your question? This is how you do SQL with RDML. Perhaps you could make a suggestion in the 'Product Enhancement Forum'
by soa
Fri Aug 31, 2018 10:26 am
Forum: Questions & Answers
Topic: Convert SQL to RDMLX?
Replies: 11
Views: 2218

Re: Convert SQL to RDMLX?

I just built this a couple of minutes ago. Without select_sql I would have had to build two select loops with appropriate logicals and a fetch. I was able to test this select logic in the green screen sql function before hand and I know that if I was to debug this I could add a breakpoint to the sel...
by soa
Fri Aug 31, 2018 9:40 am
Forum: Questions & Answers
Topic: Convert SQL to RDMLX?
Replies: 11
Views: 2218

Re: Convert SQL to RDMLX?

I think having to handle quotes is a small price to pay for accessing the full functionality of sql within an RDMLX function. The speed improvements over traditional SELECT and FECH type coding can be astounding.
by soa
Thu Aug 30, 2018 9:08 am
Forum: Questions & Answers
Topic: Convert SQL to RDMLX?
Replies: 11
Views: 2218

Re: Convert SQL to RDMLX?

Why wouldn't you just build a select_sql statement with using then put the insert inside the loop?
by soa
Tue Aug 21, 2018 4:09 pm
Forum: Questions & Answers
Topic: I’d like to get some feedback / discussion going on these 2 questions …………….
Replies: 6
Views: 2244

Re: I’d like to get some feedback / discussion going on these 2 questions …………….

My organisation offers users a choice of Chrome, Firefox & IE

Windows 7 in currently in the process of being replaced by Windows 10 across the organisation.
by soa
Mon Aug 20, 2018 10:16 am
Forum: Questions & Answers
Topic: base64
Replies: 3
Views: 1647

Re: base64

Thanks Tony
by soa
Sat Aug 18, 2018 4:03 pm
Forum: Questions & Answers
Topic: base64
Replies: 3
Views: 1647

base64

The jira api requires that I concat my username and a token and then base 64 encode it. Is this possible in LANSA?
by soa
Fri Aug 10, 2018 11:01 am
Forum: Questions & Answers
Topic: Record to be updated has been changed error
Replies: 5
Views: 2005

Re: Record to be updated has been changed error

Sounds like a support issue to me.
by soa
Fri Aug 03, 2018 11:06 am
Forum: Questions & Answers
Topic: Re-Captch Using V13
Replies: 4
Views: 1312

Re: Re-Captch Using V13

I can't help you with WAMs but I believe that you can create user defined widgets implmenting HTML elements and javascript. In which case you need include <script src='https://www.google.com/recaptcha/api.js'></script> and <div class="g-recaptcha" data-sitekey="yoursitekey"></div> and <script type="...
by soa
Thu Aug 02, 2018 3:56 pm
Forum: Questions & Answers
Topic: Re-Captch Using V13
Replies: 4
Views: 1312

Re: Re-Captch Using V13

Which product are you using. WEBEVENT, WAM..?
by soa
Wed Aug 01, 2018 3:57 pm
Forum: Questions & Answers
Topic: Control allowed characters (DBCS/SBCS) for PRIM_MD.Edit field
Replies: 7
Views: 2069

Re: Control allowed characters (DBCS/SBCS) for PRIM_MD.Edit field

James How would you dynamically create and destroy an Editfield. Is this then associated with the PRIM_MD.Edit field? Character by character filtering is fine on the web but if the application is running on a mobile device you want the correct keyboard to pop-up. ie if a field should be numeric then...
by soa
Thu Jul 19, 2018 11:17 am
Forum: Suggestions for Product Enhancements
Topic: Debugging improvements
Replies: 2
Views: 8740

Debugging improvements

When debugging RDMLX function I am almost always interested in the contents of #IO$STS. At the moment it is listed alphabetically with the other fields but since it is a 'special' value that is always present it would be convenient if it were permanently pinned in one location. This way I wouldn't a...