Search found 26 matches

by Fromm603
Fri May 07, 2021 11:26 pm
Forum: Questions & Answers
Topic: APIs - How to?
Replies: 5
Views: 3707

Re: APIs - How to?

And I am on V15 EPC 150020.
by Fromm603
Fri May 07, 2021 10:53 pm
Forum: Questions & Answers
Topic: APIs - How to?
Replies: 5
Views: 3707

Re: APIs - How to?

Thanks !! I am actually hoping to call this from an RPGLE program on the IBMi.
by Fromm603
Fri May 07, 2021 7:56 am
Forum: Questions & Answers
Topic: APIs - How to?
Replies: 5
Views: 3707

APIs - How to?

So, I am a green screen guy, still kind of new to LANSA. Is there a good source to learn (or find open source) for doing APIs ? Specifically, I want to do a put to UPS (need to send return labels), then I need puts and gets for Shopify. Are there functions in LANSA to do this? I will not be publishi...
by Fromm603
Fri Oct 23, 2020 3:08 am
Forum: Questions & Answers
Topic: & returning &
Replies: 4
Views: 3248

Re: & returning &

HTML.
by Fromm603
Thu Oct 22, 2020 1:47 am
Forum: Questions & Answers
Topic: & returning &
Replies: 4
Views: 3248

& returning &

I have a field in a LANSA defined file that is a CLOB. When I do an SQL in an SQLRPGLE program to retrieve the data the character '&' returns '&'.
How do I stop this? What causes this? Are there other characters this will happen to?
by Fromm603
Fri Aug 07, 2020 8:06 am
Forum: Questions & Answers
Topic: Virtual Field
Replies: 1
Views: 1728

Virtual Field

Trying to create my first virtual field. Our IBMi database stores the date in 4, 2 character fields (each 2,0). I want to create a virtual field that is MMDDYY (don't need century). My virtual field derivation looks like the below, is there a better way? #SOendymd := (#soendy.AsString + #soendm.AsSt...
by Fromm603
Fri Sep 27, 2019 8:03 am
Forum: Questions & Answers
Topic: Screen designs
Replies: 1
Views: 1146

Screen designs

So I am trying to design and code a fairly simple set of screens, almost like the VLF-ONE example for orders, except, I need the order line detail. So an instance list to select orders for a customer, once the order is clicked, I want to show header and detail (the detail being a subfile, IBM i term...
by Fromm603
Thu Sep 12, 2019 5:20 am
Forum: Questions & Answers
Topic: Report with images
Replies: 6
Views: 2620

Re: Report with images

Mark,
Not quite sure what that means (PDFs on our IBMi?). We bought LANSA to do these things (images on a report or screen). But it's not quite as advertised.
The person here, uses a product called Adobe Indesign, but that's a painfully manual process. I wanted to automate things.
by Fromm603
Wed Sep 11, 2019 5:06 am
Forum: Questions & Answers
Topic: Report with images
Replies: 6
Views: 2620

Report with images

Anyone know the best way to create reports that contain images using LANSA? I am experimenting with the #Report method, but it simply doesn't handle images well at all. Some images are more vertical, some more horizontal. The images lose so much quality (and aspect ratio) they simply look horrible. ...
by Fromm603
Wed Jul 31, 2019 11:09 pm
Forum: Questions & Answers
Topic: VLF-One Printing (RESOLVED)
Replies: 5
Views: 2107

Re: VLF-One Printing (RESOLVED)

Is there a way to check if the image exists before issuing the uInsertImage command ?
by Fromm603
Thu Jul 25, 2019 7:15 am
Forum: Questions & Answers
Topic: #report.uInsertImage SourcePath (RESOLVED)
Replies: 3
Views: 1425

#report.uInsertImage SourcePath (RESOLVED)

So, I am trying to create my first report using LANSA, and am using the examples DF_T69H10 thru H40. I can find no documentation on using the #REPORT command (or someone please correct me on what it is called). I want images on my report. The images are stored on a non IBMi server, on our network. T...
by Fromm603
Thu Jul 25, 2019 2:07 am
Forum: Tips and Techniques
Topic: VF_BasicGoogleChart widget definition
Replies: 6
Views: 9338

Re: VF_BasicGoogleChart widget definition

Mark, As I run the handler, I have used sys.web.alerts to show me what processes are running. So when the handler is called the first time, I understand it should do uInitalize at that time (like INZSR fr us RPG folks). But then I would expect it to run the same routines as when just clicking a new ...
by Fromm603
Tue Jul 23, 2019 12:22 am
Forum: Tips and Techniques
Topic: VF_BasicGoogleChart widget definition
Replies: 6
Views: 9338

Re: VF_BasicGoogleChart widget definition

MarkDale, I am new to LANSA, Is there an easy way to incorporate a Google chart as part of the command handler, and not the entire screen area? So I want more on the screen, besides the chart, I only want the chart (a bar chart with 3 bars) to fill part of the screen. I have spent an amazing amount ...
by Fromm603
Sat Jul 20, 2019 5:18 am
Forum: Questions & Answers
Topic: PDF creation
Replies: 3
Views: 1799

PDF creation

Can I use VL to create a PDF report? We don't have Integrator (unless somehow that is included in VL). I want to be able to create a fairly simple item report, with item, some text, and the item image. Basically a checklist of items in a shipment. If so, is there a sample application that comes with...
by Fromm603
Tue Jun 25, 2019 12:05 am
Forum: Questions & Answers
Topic: VLF-ONE Programming 101
Replies: 2
Views: 1379

Re: VLF-ONE Programming 101

Thank you very much !! :)
by Fromm603
Sat Jun 22, 2019 5:22 am
Forum: Questions & Answers
Topic: VLF-ONE Programming 101
Replies: 2
Views: 1379

VLF-ONE Programming 101

So, I am using VL Frameworks (LANSA recommendation). First I have an application and business object, then... I have a Filter, Instance, and command handler. MY filter works fine (so my server module is working fine too), and produces an instance list of items (Including descriptions and other field...
by Fromm603
Thu Jun 13, 2019 7:38 am
Forum: Questions & Answers
Topic: SQL Join
Replies: 9
Views: 3630

Re: SQL Join

Thanks Art, it was simply the missing comma between fields on the SQL.
by Fromm603
Thu Jun 13, 2019 6:11 am
Forum: Questions & Answers
Topic: SQL Join
Replies: 9
Views: 3630

Re: SQL Join

Yikes, I get this error on the IBMi Message . . . . : Fatal Error : Component : FVL_IM__5 Server Module Statement : 78 Message : DBM Error : Column specified (1) is out of range for SQLDA (max is 2) Routine : Derive_Column_Map_from_Func. Statement 78 #SqlStatement := "SELECT IM.IMITNO IM.IMDESC FROM...
by Fromm603
Thu Jun 13, 2019 2:56 am
Forum: Questions & Answers
Topic: SQL Join
Replies: 9
Views: 3630

Re: SQL Join

Top notch gents !!! Thanks
by Fromm603
Wed Jun 12, 2019 7:30 am
Forum: Questions & Answers
Topic: SQL Join
Replies: 9
Views: 3630

SQL Join

Is there a best practice or easy method for doing an SQL join? I am in the server module creating an instance list, the filter allows for search on a description field, that is not in my primary file, my primary file has a code. I use that code to get from file A to B (along with a hard coded key va...