Search found 60 matches

by lawingo
Thu Sep 03, 2020 10:23 pm
Forum: Questions & Answers
Topic: Prompter Field Data Transfer
Replies: 3
Views: 167

Re: Prompter Field Data Transfer

Instead of creating the prompter within the field itself you can turn the prompter option on after you have placed that field onto a screen. Define_Com Class(#GOPMPTNO.Visual) Parent(#BODY_HEAD) Displayposition(5) Tabposition(5) Left(4) Top(104) Width(463) Showprompter(True) Readonly(True) Then use ...
by lawingo
Tue Aug 18, 2020 6:55 am
Forum: Questions & Answers
Topic: VL-WEB - list inside a list
Replies: 3
Views: 301

Re: VL-WEB - list inside a list

Could you not do a Tree View? I have done a Tree List Unlevelled of Parent Parts that will load a list of Child Parts when expanded. I'll be glad to share some of the high points of making it happen if that sounds like what you need.

Best,
Chad
Sherrill Furniture Co
by lawingo
Tue May 26, 2020 2:46 am
Forum: Questions & Answers
Topic: A Question about VL & Web Data Access
Replies: 3
Views: 784

Re: A Question about VL & Web Data Access

That's what I figured. Thanks for the feedback!

Best,
Chad
by lawingo
Fri May 22, 2020 1:29 am
Forum: Questions & Answers
Topic: A Question about VL & Web Data Access
Replies: 3
Views: 784

A Question about VL & Web Data Access

All of our development thus far has been VL. Every file I create has a corresponding "Shared Routine" Reusable part that contains all the Routines to Fetch, Add, Update, Delete all data for that particular file in one single object. This "Shared Routine" has method routines that receive the paramete...
by lawingo
Mon Apr 06, 2020 10:56 pm
Forum: Questions & Answers
Topic: Fusioncharts & VLWEB
Replies: 2
Views: 1390

Re: Fusioncharts & VLWEB

I am not all that familiar with Fusion charts but I did see that Lansa 15 will have native chart controls for VL Web included. Not sure if you had seen the announcement.

https://blog.lansa.com/general/visual-l ... en-better

Best,
Chad
by lawingo
Thu Mar 12, 2020 1:17 am
Forum: Questions & Answers
Topic: CLOB to BLOB (RESOLVED)
Replies: 1
Views: 1177

Re: CLOB to BLOB

So I got it working. I had to remove the header info(data:image/png;base64,) from the CLOB String to get the encoding correct. Just in case someone else out there has set up your DB to capture images with CLOBs and you would like to convert to BLOB here is your code: #listcount := #base64.CurChars #...
by lawingo
Wed Mar 11, 2020 8:11 am
Forum: Questions & Answers
Topic: CLOB to BLOB (RESOLVED)
Replies: 1
Views: 1177

CLOB to BLOB (RESOLVED)

I have images stored as CLOB data in a database file. Currently to display this CLOB data on the web I have a routine that disassembles the string and reassembles it using 65k chunks. I then set the image on the screen: #ExitPhoto.CurrentItem.Image <= #SYS_APPLN.CreateBitmap( #Base64 ) Everything wo...
by lawingo
Tue Feb 18, 2020 7:17 am
Forum: Questions & Answers
Topic: DCTRGENVUE - Lansa DB Trigger User Exit Program
Replies: 2
Views: 1367

Re: DCTRGENVUE - Lansa DB Trigger User Exit Program

I created a CL called DCTRGENVUE in the library where all my Production files exist. Here is the CL PGM PARM(&PGMLIB &PARTITION &LANGUAGE &DATEFMTSRC) DCL VAR(&PGMLIB) TYPE(*CHAR) LEN(10) DCL VAR(&PARTITION) TYPE(*CHAR) LEN(3) DCL VAR(&LANGUAGE) TYPE(*CHAR) LEN(4) DCL VAR(&DATEFMTSRC) TYPE(*CHAR) LE...
by lawingo
Tue Jan 14, 2020 2:03 am
Forum: Questions & Answers
Topic: How to show a field as checkbox
Replies: 5
Views: 923

Re: How to show a field as checkbox

Open the Field in the Repository and click the Visualization tab. Here is the code I use. I typically create an Alpha (1) field and use the below visualization. Customize the N & Y to suite your needs. Begin_Com Role(*EXTENDS #PRIM_OBJT) Begin_Com Role(*Visual #PRIM_EVEF) Name(#VisualEdit) Component...
by lawingo
Tue Oct 01, 2019 4:44 am
Forum: Questions & Answers
Topic: Base64 string longest length
Replies: 2
Views: 1734

Re: Base64 string longest length

Hey Art, I'm doing something similar in one of my applications. Keep in mind I am using the Camera Widget. I created a CLOB field to hold the base64 string(s). Reusable Part to Capture the Image: Evtroutine Handling(#CameraControl.Completed) Base64data(#base64) File(#file) Define_Com Class(#wbepSM01...
by lawingo
Wed Jul 31, 2019 1:13 am
Forum: Questions & Answers
Topic: Activex error for one user
Replies: 13
Views: 3003

Re: Activex error for one user

Image

Here is what I use. This is under "Other Components" when looking at the ActiveX Component Browser.

Hope it helps.
Chad
by lawingo
Tue Jul 30, 2019 9:55 pm
Forum: Questions & Answers
Topic: Activex error for one user
Replies: 13
Views: 3003

Re: Activex error for one user

The version of Word on the deployed computer must be the same as the version registered in the Active X.
by lawingo
Thu Jul 25, 2019 4:11 am
Forum: Questions & Answers
Topic: Visual Style in Grid Cell (SOLVED)
Replies: 7
Views: 984

Re: Visual Style in Grid Cell

Try this:

Code: Select all

Set Com(#GridColumn6.Cell<1>.Column) VisualStyle(#FS_BLUE) 
#GridColumn6 is the name of the Column in your list
<1> is the Record Number
by lawingo
Thu Jul 25, 2019 4:03 am
Forum: Questions & Answers
Topic: VLF-WIN does not launch from IDE tool bar (SOLVED)
Replies: 3
Views: 664

Re: VLF-WIN does not launch from IDE tool bar

I've ran into this - not in exactly the way you have explained but something similar. If you execute "UF_EXEC" with additional parameters, is the Render type = 'X'? My guess is possibly the last Form you executed was with Rendor='X' and that value is being defaulted(remembered) when you execute the ...
by lawingo
Fri Jun 28, 2019 9:59 pm
Forum: Questions & Answers
Topic: Mobile Dataset Question
Replies: 5
Views: 965

Re: Mobile Dataset Question

Awesome! Thanks. I'll give it a look

Best,
Chad
by lawingo
Fri Jun 28, 2019 3:04 am
Forum: Questions & Answers
Topic: Mobile Dataset Question
Replies: 5
Views: 965

Re: Mobile Dataset Question

Marcus, Thanks for the reply! I'm excited that what I want to accomplish is doable. I have my feet wet with VL-WEB but by no means an expert. I do have one question: 1. How are tables defined on the local mobile client? You said , "but with some newer features we're now able to define a local set of...
by lawingo
Thu Jun 27, 2019 1:26 am
Forum: Questions & Answers
Topic: Mobile Dataset Question
Replies: 5
Views: 965

Mobile Dataset Question

We have a standalone Windows application for our sales force that allows them take inventory at various store locations. The application allows the user to download a Master list from our FTP Server and then they can create inventory lists against the Master list. The application allows the user to ...
by lawingo
Wed Apr 17, 2019 10:57 pm
Forum: Questions & Answers
Topic: Give focus to an Edit field in a PRIM_MD.List or PRIM_LIST?
Replies: 3
Views: 11173

Re: Give focus to an Edit field in a PRIM_MD.List or PRIM_LIST?

Code: Select all

* Select 1st Record
Selectlist Named(#GridMain)
Set Com(#GridColumn6.Cell<1>.Column) Focus(True) Selected(True) Ensurevisible(True)
Set Com(#GridMain.CurrentItem) Selected(True) Focus(True) Ensurevisible(True)

Leave
Endselect

#GridMain.SetFocus
Hope this helps.

Best,
Chad
by lawingo
Tue Apr 16, 2019 10:24 pm
Forum: Questions & Answers
Topic: Scheduling thru Windows Task Scheduler
Replies: 1
Views: 8472

Scheduling thru Windows Task Scheduler

We transfer data from our iSeries to a Windows Server that is used for a Dealer Portal. The transfer happens about 4:30 am and is automated through Windows Task Scheduler. Up until about a month ago everything worked (nothing changed, unless maybe a Windows Update?). Now the Scheduled Job fires and ...
by lawingo
Thu Apr 11, 2019 4:49 am
Forum: Questions & Answers
Topic: ODBC Error Invalid Column Name when adding new Field
Replies: 5
Views: 19848

Re: ODBC Error Invalid Column Name when adding new Field

Hey Joe, The collation of the database is case-sensitive and the case of the column name specified in the query does not match the case of the column defined in the table. For example, when a column is defined in a table as LastName and the database uses a case-sensitive collation, queries that refe...