Search found 51 matches

by lawingo
Tue Oct 01, 2019 4:44 am
Forum: Questions & Answers
Topic: Base64 string longest length
Replies: 2
Views: 677

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 (RESOLVED)
Replies: 8
Views: 380

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 (RESOLVED)
Replies: 8
Views: 380

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

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

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

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

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

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

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

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

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...
by lawingo
Wed Apr 10, 2019 11:24 pm
Forum: Questions & Answers
Topic: Colspan + Rowspan within a #PRIM_LIST
Replies: 3
Views: 5671

Re: Colspan + Rowspan within a #PRIM_LIST

Hey Josh, What version of Lansa are you using? In Lansa 14, create a layout with 2 columns. In your 2nd column drop, a Panel and set the size to "fit Both." Create a layout for the Panel and set it to 2 rows Best, Chad Here's an example: * ************************************************** * * COMPO...
by lawingo
Mon Mar 11, 2019 11:14 pm
Forum: Questions & Answers
Topic: Error with BLOB Image
Replies: 2
Views: 1780

Re: Error with BLOB Image

Awesome Guess! Thanks for your help!
by lawingo
Sat Mar 09, 2019 1:41 am
Forum: Questions & Answers
Topic: Error with BLOB Image
Replies: 2
Views: 1780

Error with BLOB Image

Has anyone seen this before? The user gets this error when trying to save a BLOB image. The JOB doesn't exist anymore and I'm not sure how to track down *LOB_UNIQUE_FILENAME. Google hasn't been much help. The program is running in a Windows environment saving the image to an iSeries file. Thanks Cha...
by lawingo
Fri Mar 08, 2019 7:56 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4867

Re: Decimal / Percent Conversion and Display

I hard coded your values. My end result was 114%. I was confused at how you could even get 113 when your value was clearly 1.140000. Also, I didn't throw the values to a screen. I just used a "MESSAGE_BOX_ADD" to show me the values. I would assume that shouldn't make a difference. What is the Defini...
by lawingo
Fri Mar 08, 2019 6:38 am
Forum: Questions & Answers
Topic: Decimal / Percent Conversion and Display
Replies: 8
Views: 4867

Re: Decimal / Percent Conversion and Display

Could you change the wk_percent field to a String field and then format it with the following? Define Field(#wk_Percent1) Type(*STRING) Define Field(#wk_Percent2) Type(*STRING) #BPU1 := .14000 #BPU2 := 1.14 #wk_Percent1 := (#BPU1 * 100).Round.AsDisplayString( EditCode_Z ) + '%' #wk_Percent2 := (#BPU...
by lawingo
Wed Mar 06, 2019 11:57 pm
Forum: Questions & Answers
Topic: Using Exec_Os400 command in V13
Replies: 14
Views: 6602

Re: Using Exec_Os400 command in V13

We build our string first and execute the AS400 command from a server function instead of embedding the string in the arguments: This code is used for sending an email. It works great! #W_CMD := 'SNDSMTPEMM RCP((' + #EMAILTO + ')) SUBJECT(' + "'" + #emailsbj + "'" + ') NOTE(' + "'" + #emailmsg + "'"...
by lawingo
Sat Feb 16, 2019 5:01 am
Forum: Questions & Answers
Topic: Importing IBM i Duplicate Fields
Replies: 3
Views: 1835

Re: Importing IBM i Duplicate Fields

Hey Joe, In your code you will have to reference the "RPU001" field when referring to that file. When you update the file on the ibm it will update the "RPU" field correctly even though the field name is "RPU001". Since the file is an "OTHER" file, Lansa simply maps the field to the other field base...
by lawingo
Thu Feb 14, 2019 4:35 am
Forum: Questions & Answers
Topic: Set Focus to Cell in Grid
Replies: 2
Views: 1891

Re: Set Focus to Cell in Grid

Bingo!

Thanks for your help.
by lawingo
Tue Feb 12, 2019 3:18 am
Forum: Questions & Answers
Topic: Set Focus to Cell in Grid
Replies: 2
Views: 1891

Set Focus to Cell in Grid

Hopefully an easy Question: I want to select the 1st Record in a grid and set focus to a cell in the 1st Row. In my example, the cell I want to set focus to is "GridColumn6". The code below selects the 1st record and it visually sets focus to the cell I want but I still have to click in the Cell in ...