Search found 67 matches

by lawingo
Wed Nov 25, 2020 3:49 am
Forum: Questions & Answers
Topic: Virtual Field Type
Replies: 2
Views: 27

Re: Virtual Field Type

My 1st question would be why would you not use the Date Field Format ? - Especially if you are using RDMLX tables. But to answer your question... What are the Field types of the Virtual Fields you are using? Our company used the same format you are trying to set up and we would use (S8,0) for both t...
by lawingo
Thu Nov 12, 2020 4:36 am
Forum: Questions & Answers
Topic: Picklist Visualization
Replies: 2
Views: 84

Re: Picklist Visualization

Hey Art, I guess that's probably my point. The Dynamic Picklist has a Caption Property and a Value Property. The Caption is the Visible column when placed on a Form, the Value is the visible column when dropped into a Grid/List. I would expect the Caption to always be the visible column. Thanks for ...
by lawingo
Thu Nov 12, 2020 3:52 am
Forum: Questions & Answers
Topic: Picklist Visualization
Replies: 2
Views: 84

Picklist Visualization

I have created a Dynamic Picklist Visualization for a field in one of my files. #Picklist.Add Caption(#Y071NMU) Value(#Y071ID.AsSTring) I have added the visualization on an ID Field with the caption of the Name of the record <see above>. For Example, ID= 1, Name = Apples. So if you add the ID to a F...
by lawingo
Sat Nov 07, 2020 12:31 am
Forum: Questions & Answers
Topic: VLF-WIN V14 SP2 and performance
Replies: 5
Views: 261

Re: VLF-WIN V14 SP2 and performance

Yes & No <grin> If you look back at the code for "FNCR_DM" in my previous reply, the Method Routine executes a subroutine that will clear both the exchange list and the array List "#PRIM_ACOL<#FNCR_DO>". I always keep the array list and the exchange list basically the same. The EXCHANGE list gets pa...
by lawingo
Wed Nov 04, 2020 1:30 am
Forum: Questions & Answers
Topic: VLF-WIN V14 SP2 and performance
Replies: 5
Views: 261

Re: VLF-WIN V14 SP2 and performance

FNCR_DO (RP) Function Options(*DIRECT) Begin_Com Role(*EXTENDS #PRIM_OBJT *LISTFIELDS #L_FNCR) Def_List Name(#L_FNCR) Fields(#FNCRID #FNCRDVID #FNCRSTYL #FNCRFIN #FNCRSHER #FNCRSEQ #FNCRQTY #FNCRCTDT #FNCRSTCD #STSTID #MRRFCFID #MRCFTOIVV #MRCFKDINV #STSTDVNMJ #STSTMFCD #FNFSFLID #FNFSFLNMJ #FNFSFNI...
by lawingo
Sat Oct 31, 2020 2:32 am
Forum: Questions & Answers
Topic: VL IDE Deployment Tool: x_run.exe broken
Replies: 2
Views: 242

Re: VL IDE Deployment Tool: x_run.exe broken

Is this for a JIT deployment? We are on V15 and I know somewhere around V13 or V14 the Deployment tool changed. I remember having to call support when we updated because the complete methodology for deployments changed. On our JIT Deployment our packages have versions (1.0.0.0). You can either creat...
by lawingo
Sat Oct 31, 2020 2:20 am
Forum: Questions & Answers
Topic: VLF-WIN V14 SP2 and performance
Replies: 5
Views: 261

Re: VLF-WIN V14 SP2 and performance

Klaus, Do you request the data straight from the COM Handler or do you have an object that handles getting the data? For example, my com handlers will open an object dedicated for selecting the needed data (#PRIM_OBJT) and request the data from the server and then load that data into a list that the...
by lawingo
Thu Sep 03, 2020 10:23 pm
Forum: Questions & Answers
Topic: Prompter Field Data Transfer
Replies: 3
Views: 613

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

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

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

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

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

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

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

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

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

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

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

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

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