Search found 47 matches

by dhnaigles
Tue Feb 18, 2020 7:32 am
Forum: Questions & Answers
Topic: DCTRGENVUE - Lansa DB Trigger User Exit Program
Replies: 2
Views: 642

Re: DCTRGENVUE - Lansa DB Trigger User Exit Program

Thank you, Chad! I shall try this and hopefully it works.
by dhnaigles
Tue Feb 18, 2020 6:47 am
Forum: Questions & Answers
Topic: DCTRGENVUE - Lansa DB Trigger User Exit Program
Replies: 2
Views: 642

DCTRGENVUE - Lansa DB Trigger User Exit Program

I am trying to use a File Level trigger with a non-LANSA table. I want it to run as a default IBMi Database Trigger. I set everything up according to the documentation, but I don't know how to create the User Exit Program required, DCTRGENVUE, and non-LANSA programs are failing due to this issue. Ha...
by dhnaigles
Wed Feb 05, 2020 2:42 am
Forum: Questions & Answers
Topic: fetching record with BLOB column via RRN does not invoke trigger
Replies: 3
Views: 389

Re: fetching record with BLOB column via RRN does not invoke trigger

Art, we are in the process of removing the BLOB field from the table and putting the documents into a NAS. Our document table is already hundreds of gigabytes and growing daily. the goal is to put all the documents into a NAS and then have the BLOB field as a virtual field and use the trigger to ret...
by dhnaigles
Tue Feb 04, 2020 5:22 am
Forum: Questions & Answers
Topic: fetching record with BLOB column via RRN does not invoke trigger
Replies: 3
Views: 389

fetching record with BLOB column via RRN does not invoke trigger

I am trying to retrieve a record from a table on the IBMi with a BLOB column, sic DXDOCS, via Relative Record Number. The table has a file-level trigger, but when I do the fetch, the after_read is not invoked. Is there an issue with invoking the trigger when fetching with_rrn?
by dhnaigles
Tue May 21, 2019 11:08 pm
Forum: Questions & Answers
Topic: What's going on @ LANSA?
Replies: 11
Views: 1878

Re: What's going on @ LANSA?

Well I received a call from "Obi-Wan Kenobi" (also known as Pete Draney). I was very encouraged by the fact that he is still involved with LANSA affairs at this time and I am willing to give Idera the benefit of the doubt for now and wait and see what the future will hold. While I have some concerns...
by dhnaigles
Tue May 21, 2019 6:55 am
Forum: Questions & Answers
Topic: New To Visual Lansa
Replies: 13
Views: 11550

Re: New To Visual Lansa

Fromm603, There is online training available (for a price). If you are building a VLF_WIN application, you will find tutorials in the VLF documentation. If you are having issues with layouts, it might be best if you use the samples and look for Table Layout. There are many examples of windows and we...
by dhnaigles
Tue May 21, 2019 6:41 am
Forum: Questions & Answers
Topic: Lansa Editor on virtual machine
Replies: 16
Views: 18323

Re: Lansa Editor on virtual machine

I regularly have to reboot my Terminal Services (Remote Desktop) server. It seems that multiple users over time will use memory that does not seem to release when they leave VL.
by dhnaigles
Tue May 21, 2019 6:38 am
Forum: Questions & Answers
Topic: What's going on @ LANSA?
Replies: 11
Views: 1878

Re: What's going on @ LANSA?

It is a bit distressing when so many experienced lansa employees are leaving the company. I, too, have had a very tough time explaining/justifying to my senior management that our decision to use LANSA as our main development platform may not have been the correct one. It was correct at the time, bu...
by dhnaigles
Wed Nov 14, 2018 11:31 pm
Forum: Questions & Answers
Topic: Offline(local) "database" storage in LANSA Mobile
Replies: 12
Views: 4559

Re: Offline(local) "database" storage in LANSA Mobile

Marcus I use localStorage and have the key start with a particular value. Here is my code for storing and retrieving images: Mthroutine Name(GetBlobData) Define_Map For(*INPUT) Class(#Signature) Name(#SaveSig) Define Field(#sigFileName) Type(*STRING) #DELLOC := #sys_web.LocalStorage<Location>.Value....
by dhnaigles
Sat Jul 21, 2018 3:19 am
Forum: Questions & Answers
Topic: using bitmaps and visual styles in SP2 VLF-WIN
Replies: 1
Views: 695

using bitmaps and visual styles in SP2 VLF-WIN

We have been using our own bitmaps in VLF-WIN for 3 years. Once we upgraded to SP2, our bitmaps only show up if the component is renderstyle(DirectX) and any visual styles that have a non-black text color only show the correct text color in renderStyle(Win32). This is becoming a very bad issue for u...
by dhnaigles
Fri Jul 06, 2018 7:26 am
Forum: Questions & Answers
Topic: VL-Web V14SP1: the way to acquire the device ID in the VL-WEB program
Replies: 2
Views: 2040

Re: VL-Web V14SP1: the way to acquire the device ID in the VL-WEB program

While we have been unable to read the device id, we are using a web page to load unique device id's into each devices localstorage and using this to both validate that the device is registered to be using the web page and to stamp the appropriate records in our tables with that device id. I hope thi...
by dhnaigles
Fri Jul 06, 2018 1:10 am
Forum: Questions & Answers
Topic: Overriding the msi installation paths in the deployment tool
Replies: 3
Views: 1223

Overriding the msi installation paths in the deployment tool

We are building a new deployment for our VLF-WIN app to upgrade to SP2 for our 250 users. I have not used the deployment tool in a while and now, at least in SP2, when the msi package is run, it is put into a folder in the users personal folders (c:\users\{logged on user}\appdata\local\apps\Phoenix ...
by dhnaigles
Thu Jul 05, 2018 11:00 pm
Forum: Questions & Answers
Topic: LANSA IDE "Deliver To" a different Partition?
Replies: 3
Views: 1113

Re: LANSA IDE "Deliver To" a different Partition?

You can also use quickexport and import it into your target partition in VL then "Deliver To"
by dhnaigles
Thu Jul 05, 2018 10:56 pm
Forum: Questions & Answers
Topic: VL Web Pages - Library List of QHTTPSVR-Jobs
Replies: 2
Views: 1061

Re: VL Web Pages - Library List of QHTTPSVR-Jobs

I believe that the VLWeb Pages still use LWEB_JOB and that will have the correct library list for the user. If you changed that users library list, you should clean up your web server, using the Web Adminstrator or its associated command on the iSeries. This will restart all your LWEB_JOBs and have ...
by dhnaigles
Fri Mar 09, 2018 12:44 am
Forum: Questions & Answers
Topic: Offline(local) "database" storage in LANSA Mobile
Replies: 12
Views: 4559

Re: Offline(local) "database" storage in LANSA Mobile

Thank you very much, James. You are a credit to your father!
by dhnaigles
Tue Mar 06, 2018 11:53 pm
Forum: Questions & Answers
Topic: Offline(local) "database" storage in LANSA Mobile
Replies: 12
Views: 4559

Re: Offline(local) "database" storage in LANSA Mobile

Greg
I looked at the xFileRead and Write, but there is no documentation other than the widgets themselves. Do you, or anyone, have a little sample code for how to implement the widget?
by dhnaigles
Tue Mar 06, 2018 2:56 am
Forum: Questions & Answers
Topic: Offline(local) "database" storage in LANSA Mobile
Replies: 12
Views: 4559

Re: Offline(local) "database" storage in LANSA Mobile

Stewart,
I am already using LocalStorage for much of my data, but I have BLOB data (Signatures and Camera Photos) which needs to be stored in there. Will PRIM_WEB.Json allow the use of BLOB fields to be stored in the array or collection?
by dhnaigles
Sat Mar 03, 2018 4:59 am
Forum: Questions & Answers
Topic: Offline(local) "database" storage in LANSA Mobile
Replies: 12
Views: 4559

Offline(local) "database" storage in LANSA Mobile

Does anyone have any ideas about storing database records locally in LANSA Mobile. LongRange had the ability to create and maintain local database objects and records, but this does not seem to be available in LANSA Mobile Web Pages. I have a VL Web Page that stores data, that has been changed while...
by dhnaigles
Fri Feb 02, 2018 6:19 am
Forum: Questions & Answers
Topic: Sending HTTP Request with XML Data (but no <?xml version="1.0"?>)
Replies: 0
Views: 1392

Sending HTTP Request with XML Data (but no <?xml version="1.0"?>)

It's been quite a while since I've used Integrator to access web APIs. I need to create an HTTP Request which results in the following URL being posted: https://production.shippingapis.com/ShippingAPI.dll?API=CityStateLookup&XML=<CityStateLookupRequest USERID="xxx"><ZipCode ID= "0"><Zip5>01752</Zip5...
by dhnaigles
Sat Nov 18, 2017 3:00 am
Forum: Questions & Answers
Topic: Email validation/masking in VL Web
Replies: 3
Views: 1823

Email validation/masking in VL Web

does anyone have a sample of telling VLWeb that a text box is an email address and validating that it is "correct"? WAMs have a way of doing this, but I cannot figure out a VL Web equivalent? Maybe a regular express? Has anyone done this and could you provide a sample? Thanks in advance
david