Search found 20 matches

by Fromm603
Fri Sep 27, 2019 8:03 am
Forum: Questions & Answers
Topic: Screen designs
Replies: 1
Views: 154

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: 354

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: 354

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: 307

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: 231

#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: 358

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: 358

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: 228

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: 243

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: 243

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: 587

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: 587

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: 587

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: 587

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...
by Fromm603
Wed Jun 05, 2019 4:19 am
Forum: Questions & Answers
Topic: Instance List - 1 record or many
Replies: 2
Views: 203

Re: Instance List - 1 record or many

Thanks, yes VLF has that option, and I missed that originally. I changed the source to CONTAINS from EQ, it didn't work, but then I cleared cache and for some odd reason it was good to go.
by Fromm603
Wed Jun 05, 2019 12:13 am
Forum: Questions & Answers
Topic: Instance List - 1 record or many
Replies: 2
Views: 203

Instance List - 1 record or many

So, I am new to LANSA. I have a filter and instance list. When I type in a value in the filter (Item # in my case), only 1 entry is shown in the insance list (an exact match), but what I want is basically all records that contain the value I entered. So we have items D10, D1007A, D1089 (and way more...
by Fromm603
Tue May 07, 2019 7:51 am
Forum: Questions & Answers
Topic: New To Visual Lansa
Replies: 13
Views: 11325

Re: New To Visual Lansa

OK, with the help from some of the above comments, I have a simple inquiry screen, kind of working. Also a lot of help from my remote mentoring. I have a 3 row, 1 column command handler. The 1st and 3rd rows will contain some general data, the 2nd row has a 4 column list. (I used the layout manager)...
by Fromm603
Wed May 01, 2019 12:32 am
Forum: Questions & Answers
Topic: New To Visual Lansa
Replies: 13
Views: 11325

Re: New To Visual Lansa

Thanks all. I just need to show my boss that I can accomplish something, a simple inquiry screen, over 1 file. So where do I start? I am using the Frameworks. So I add a business object, create an instance list (I'll need 2 files here, so no idea how that'll work), a filter (simple hidden?) and a co...
by Fromm603
Tue Apr 30, 2019 7:33 am
Forum: Questions & Answers
Topic: New To Visual Lansa
Replies: 13
Views: 11325

Re: New To Visual Lansa

Rene, I am in the Chicago area.
by Fromm603
Tue Apr 30, 2019 1:54 am
Forum: Questions & Answers
Topic: New To Visual Lansa
Replies: 13
Views: 11325

New To Visual Lansa

I am a long time IBMi (RPGLE) guy. Does anyone have a roadmap on learning VL? eLearning, the tutorials, and even remote mentoring, just not doing the trick. I picked up and understood HTML/CSS/Javascript better.