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 ...
Search found 31 matches
- Thu Dec 08, 2022 8:01 am
- Forum: Tips and Techniques
- Topic: Blobs
- Replies: 9
- Views: 215648
- 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)....
- 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?
- 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 ...
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 ...
- 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 ...
- 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.
- 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.
- 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 ...
Are there functions in LANSA to do this?
I will not be ...
- Fri Oct 23, 2020 3:08 am
- Forum: Questions & Answers
- Topic: & returning &
- Replies: 4
- Views: 86852
Re: & returning &
HTML.
- 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?
How do I stop this? What causes this? Are there other characters this will happen to?
- 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 ...
#SOendymd := (#soendy.AsString + #soendm ...
- 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 ...
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 ...
- 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.
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.
- 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 ...
Some images are more vertical, some more horizontal. The images lose so much quality (and aspect ratio) they simply look horrible ...
- 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 ?
- 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 ...
I want images on my report. The images are stored on a non IBMi server, on our network ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 ...
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 ...
- 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 !! 