Search found 31 matches

by Fromm603
Thu Dec 08, 2022 8:01 am
Forum: Tips and Techniques
Topic: Blobs
Replies: 9
Views: 215648

Re: Blobs

Dino,
I created a standard file maintenance using LANSA. I told it what file I wanted to use. It did the rest, including a nice paperclip icon (for attachments), and then 1 for notes. It works great. The user can manually add attachments, and they are stored as BLOBS, as best I Know.
So now, I have ...
by Fromm603
Wed Dec 07, 2022 7:17 am
Forum: Tips and Techniques
Topic: Blobs
Replies: 9
Views: 215648

Re: Blobs

Thanks Dino. I suspect I am not clear on my question. And shall post in the questions section in the future (I don't know what I was thinking)....
by Fromm603
Fri Dec 02, 2022 9:54 am
Forum: Tips and Techniques
Topic: Spreadsheets
Replies: 2
Views: 153839

Spreadsheets

Is there a technique I can use to get LANSA generated spreadsheets to a Network drive instead of my IFS?
by Fromm603
Fri Dec 02, 2022 9:52 am
Forum: Tips and Techniques
Topic: Blobs
Replies: 9
Views: 215648

Blobs

Is there a way to incorporate a PDF that's on my IFS into a Blob in LANSA?
I use LANSA to create my database (let's say an invoice file). It allows me the paper clip icon to attach documents using the UI. Well now I have an IBMi job that creates a PDF on my IFS, that I'd like to make available in ...
by Fromm603
Thu Aug 12, 2021 2:27 am
Forum: Questions & Answers
Topic: APIs for Shopify
Replies: 0
Views: 52386

APIs for Shopify

Anyone ever develop APIs for Shopify Fulfillment? I do not want or need to create an APP. I'm just looking for what APIs and in what order I need to use them to ship an order. We use Shopify for order entry, but ship in our ERP. I am just learning REST APIs in LANSA (the tutorial is only minimally ...
by Fromm603
Fri May 07, 2021 11:26 pm
Forum: Questions & Answers
Topic: APIs - How to?
Replies: 5
Views: 16617

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

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

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 ...
by Fromm603
Fri Oct 23, 2020 3:08 am
Forum: Questions & Answers
Topic: & returning &
Replies: 4
Views: 86852

Re: & returning &

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

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

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 ...
by Fromm603
Fri Sep 27, 2019 8:03 am
Forum: Questions & Answers
Topic: Screen designs
Replies: 1
Views: 6455

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

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

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

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

#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 ...
by Fromm603
Thu Jul 25, 2019 2:07 am
Forum: Tips and Techniques
Topic: VF_BasicGoogleChart widget definition
Replies: 6
Views: 221297

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

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: 5
Views: 17826

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 ...
by Fromm603
Tue Jun 25, 2019 12:05 am
Forum: Questions & Answers
Topic: VLF-ONE Programming 101
Replies: 2
Views: 9146

Re: VLF-ONE Programming 101

Thank you very much !! :)