Search found 24 matches

by John
Fri Mar 29, 2019 11:17 am
Forum: Questions & Answers
Topic: One leading zero to all dollar values less than $1
Replies: 2
Views: 4931

Re: One leading zero to all dollar values less than $1

I copied and pasted the currency floating edit mask from one of the fields already defined in the repository and this worked: #oOverduebalance := #OverdueBal.AsDisplayString( EditWord ' , , $0 . -' ) I was using: #oOverduebalance := #OverdueBal.AsDisplayString( EditWord ' , $0. -' ) which wasn't wor...
by John
Thu Mar 28, 2019 10:33 pm
Forum: Questions & Answers
Topic: One leading zero to all dollar values less than $1
Replies: 2
Views: 4931

One leading zero to all dollar values less than $1

Hi, I'd like to know how to have one leading zero to all dollar values less than $1 (ie $0.32 rather than .32) I've tried: #oOverduebalance := #OverdueBal.AsDisplayString( EditWord ' , $00. -' ) which works for values less than $1 but obviously doesn't work for values greater than $1 as a value of 2...
by John
Tue Mar 26, 2019 1:38 pm
Forum: Questions & Answers
Topic: Server Module erroring using Select with option(*STARTKEY *BACKWARDS)
Replies: 2
Views: 4414

Re: Server Module erroring using Select with option(*STARTKEY *BACKWARDS)

Hi Mark,

I did as you suggested and it worked. Also, I don't think it liked the date 9999999 (date is a 7 digit date CYYMMDD) as part of the key.

I really appreciate your help
Cheers :-)
John.
by John
Tue Mar 26, 2019 11:10 am
Forum: Questions & Answers
Topic: Server Module erroring using Select with option(*STARTKEY *BACKWARDS)
Replies: 2
Views: 4414

Server Module erroring using Select with option(*STARTKEY *BACKWARDS)

I'm wanting to get a list of records in descending date order from a logical called ITMBYDTE. Keys CONO15 ASCEND CUSN15 ASCEND DOCD15 ASCEND ETYP15 ASCEND LREF15 ASCEND Srvroutine Name(GetARTransactionList) Field_Map For(*INPUT) Field(#CONO15) Parameter_Name(Company) Field_Map For(*INPUT) Field(#CUS...
by John
Mon Aug 27, 2018 4:35 pm
Forum: Questions & Answers
Topic: Change colour of scroll bar on a List
Replies: 0
Views: 1796

Change colour of scroll bar on a List

Hi,

I was wondering if the colour of the scroll bar can be changed. I'd like a light grey or something so it's easier to see.
lansa screenprint3.jpg
lansa screenprint3.jpg (93.68 KiB) Viewed 1796 times
by John
Fri Aug 03, 2018 4:22 pm
Forum: Questions & Answers
Topic: Edit Mask
Replies: 1
Views: 890

Edit Mask

Hi, If I use this statement: #ColumnINVT65.CurrentItem.Value := '$' + #InvEqList.InvoiceValue.AsDisplayString( EditCode_N ) It produces: lansa screenprint.jpg How do I use the Mask parameter of the AsDisplayString method to have the -ve sign in front of the $ sign and with comma separators please?
by John
Thu Jul 12, 2018 3:51 pm
Forum: Questions & Answers
Topic: Server modules
Replies: 15
Views: 8601

Re: Server modules

Hi Stewart,

This URL no longer exists. IS there an updated one please as I'm interested in reading it'

http://docs.lansa.com/14/en/lansa017/in ... 1_0415.htm

Regards,
john.
by John
Mon Mar 19, 2018 3:30 pm
Forum: Questions & Answers
Topic: Controlling Size options with list on webpage
Replies: 8
Views: 2275

Controlling Size options with list on webpage

Hi, I've experimented with the various Size options when displaying a list in a web page. Lansa Sizes 1.docx Lansa Sizes 2.docx What I am trying to achieve? - I don't want the user to have to scroll the PAGE, but I am happy for them to scroll the list WITHIN the page. - When Size: Content Height is ...
by John
Thu Mar 08, 2018 1:47 pm
Forum: Questions & Answers
Topic: Problem clicking on a row in list on webpage
Replies: 1
Views: 663

Problem clicking on a row in list on webpage

Hi, Depending how my web browser window is sized, affects my ability to click on rows towards the top of the list. eg 1. At this size, you can see when my mouse hovers over the 1st row, it is highlighted and I can therefore double-click on it. Also, when I hover over, say, the Phone column of the 1s...
by John
Fri Jan 19, 2018 12:22 pm
Forum: Questions & Answers
Topic: Adding a Picklist to an existing iSeries field
Replies: 3
Views: 1272

Re: Adding a Picklist to an existing iSeries field

No, but I have now.

I checked it in but still didn't work until I recompiled the popup editor.

Thank you very much for your help :-).
by John
Thu Jan 18, 2018 3:44 pm
Forum: Questions & Answers
Topic: Adding a Picklist to an existing iSeries field
Replies: 3
Views: 1272

Adding a Picklist to an existing iSeries field

I have a field in an iSeries file I have added a picklist to. Clipboard01.jpg I checked it in and got no errors. But when it's displayed in the Popup editor, it just shows as a regular field and not like a dropdown. Am I doing something wrong or is this just not supported for an existing iSeries fie...
by John
Thu Jan 18, 2018 1:08 pm
Forum: Questions & Answers
Topic: IF_STATUS question
Replies: 2
Views: 736

Re: IF_STATUS question

Thank you, that makes sense :-)
by John
Thu Jan 18, 2018 12:49 pm
Forum: Questions & Answers
Topic: IF_STATUS question
Replies: 2
Views: 736

IF_STATUS question

Srvroutine Name(GetServiceAdvisorDtl) Field_Map For(*Input) Field(#CONO1A) Parameter_Name(Company) Field_Map For(*Input) Field(#TPAC1A) Parameter_Name(Dealer) Field_Map For(*Input) Field(#DSEQ1A) Parameter_Name(DealerSeq) Field_Map For(*INPUT) Field(#CTNU1A) Parameter_Name(ContactNo) Group_Map For(*...
by John
Wed Nov 15, 2017 4:54 pm
Forum: Questions & Answers
Topic: Error Message "Invalid selector expression"
Replies: 1
Views: 743

Error Message "Invalid selector expression"

Hi, How are we suppose to figure out what certain error messages are? The one in red in the screenprint I don't understand. I could ask in the vlforums but they might get sick of me asking a whole heap of questions lol. I've looked online on the LANSA Support page and searched for the error message ...
by John
Wed Nov 08, 2017 1:11 pm
Forum: Questions & Answers
Topic: Delete record from file
Replies: 1
Views: 1002

Delete record from file

I'm writing a new maintenance function based on the tutorial - WAD260A – An Employee Maintenance Application ( http://docs.lansa.com/14/en/lansa097/index.htm#lansa/wadeng02_0060.htm%3FTocPath%3DExtending%2520Your%2520Web%2520Development%2520Skills%7CWAD260A%2520%25E2%2580%2593%2520An%2520Employee%25...
by John
Fri Oct 13, 2017 12:18 pm
Forum: Questions & Answers
Topic: Remove focus on first row of list on webpage
Replies: 2
Views: 1160

Re: Remove focus on first row of list on webpage

Hi Danny,

I tried that but unfortunately did not work.
by John
Thu Oct 12, 2017 12:43 pm
Forum: Questions & Answers
Topic: Remove focus on first row of list on webpage
Replies: 2
Views: 1160

Remove focus on first row of list on webpage

The first row is highlighted upon initial load of the web page acting like the first row has been clicked on.
DlrStkEnq1.jpg
DlrStkEnq1.jpg (154.92 KiB) Viewed 1160 times
Is there a way to remove this focus so it looks like this?
DlrStkEnq2.jpg
DlrStkEnq2.jpg (87.42 KiB) Viewed 1160 times
by John
Wed Sep 20, 2017 4:00 pm
Forum: Questions & Answers
Topic: The SortOnClick Property in PRIM_LIST.String
Replies: 3
Views: 1416

Re: The SortOnClick Property in PRIM_LIST.String

No, I did not have a column with sortposition of 1. I've experimented with the different sort properties. I tried sortposition(1) and the sort symbol appeared BUT clicking on it doesn't sort the column. Only when I also included sortonclick(true) was it able to be sorted. Thanks for your input guys ...
by John
Wed Sep 20, 2017 2:46 pm
Forum: Questions & Answers
Topic: The SortOnClick Property in PRIM_LIST.String
Replies: 3
Views: 1416

The SortOnClick Property in PRIM_LIST.String

http://docs.lansa.com/14/en/lansa016/PRIM_LIST.STRING_SORTONCLICK.htm The SortOnClick controls whether data is sorted when the user clicks on the column heading. When the webpage is initially displayed there is nothing to tell the user the column is sortable. sort.jpg When clicks on the Stock Age (D...
by John
Wed Sep 20, 2017 2:32 pm
Forum: Questions & Answers
Topic: Days Elapsed since Date
Replies: 3
Views: 1435

Re: Days Elapsed since Date

Thanks for both your input.

I experimented and found this works:
#StkAgeDays := #DATEX.Now.Difference( #WIDT20.asdate( xYYMMDD ) )