Search found 23 matches

by Fromm603
Fri Oct 23, 2020 3:08 am
Forum: Questions & Answers
Topic: & returning &
Replies: 4
Views: 351

Re: & returning &

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

& 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: 466

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)...