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 ...
Search found 24 matches
- Fri Mar 29, 2019 11:17 am
- Forum: Questions & Answers
- Topic: One leading zero to all dollar values less than $1
- Replies: 2
- Views: 9515
- Thu Mar 28, 2019 10:33 pm
- Forum: Questions & Answers
- Topic: One leading zero to all dollar values less than $1
- Replies: 2
- Views: 9515
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 ...
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 ...
- Tue Mar 26, 2019 1:38 pm
- Forum: Questions & Answers
- Topic: Server Module erroring using Select with option(*STARTKEY *BACKWARDS)
- Replies: 2
- Views: 9417
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.
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.
- Tue Mar 26, 2019 11:10 am
- Forum: Questions & Answers
- Topic: Server Module erroring using Select with option(*STARTKEY *BACKWARDS)
- Replies: 2
- Views: 9417
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 ...
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 ...
- Mon Aug 27, 2018 4:35 pm
- Forum: Questions & Answers
- Topic: Change colour of scroll bar on a List
- Replies: 2
- Views: 43697
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.
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.
- Fri Aug 03, 2018 4:22 pm
- Forum: Questions & Answers
- Topic: Edit Mask
- Replies: 1
- Views: 4243
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 ...
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 ...
- Thu Jul 12, 2018 3:51 pm
- Forum: Questions & Answers
- Topic: Server modules
- Replies: 15
- Views: 48249
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.
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.
- Mon Mar 19, 2018 3:30 pm
- Forum: Questions & Answers
- Topic: Controlling Size options with list on webpage
- Replies: 8
- Views: 17849
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 ...
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 ...
- Thu Mar 08, 2018 1:47 pm
- Forum: Questions & Answers
- Topic: Problem clicking on a row in list on webpage
- Replies: 1
- Views: 4483
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 ...
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 ...
- Fri Jan 19, 2018 12:22 pm
- Forum: Questions & Answers
- Topic: Adding a Picklist to an existing iSeries field
- Replies: 3
- Views: 6782
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
.
I checked it in but still didn't work until I recompiled the popup editor.
Thank you very much for your help
- Thu Jan 18, 2018 3:44 pm
- Forum: Questions & Answers
- Topic: Adding a Picklist to an existing iSeries field
- Replies: 3
- Views: 6782
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 ...
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 ...
- Thu Jan 18, 2018 1:08 pm
- Forum: Questions & Answers
- Topic: IF_STATUS question
- Replies: 2
- Views: 5696
Re: IF_STATUS question
Thank you, that makes sense 
- Thu Jan 18, 2018 12:49 pm
- Forum: Questions & Answers
- Topic: IF_STATUS question
- Replies: 2
- Views: 5696
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 ...
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 ...
- Wed Nov 15, 2017 4:54 pm
- Forum: Questions & Answers
- Topic: Error Message "Invalid selector expression"
- Replies: 1
- Views: 4071
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 ...
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 ...
- Wed Nov 08, 2017 1:11 pm
- Forum: Questions & Answers
- Topic: Delete record from file
- Replies: 1
- Views: 4718
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 ...
( 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 ...
- Fri Oct 13, 2017 12:18 pm
- Forum: Questions & Answers
- Topic: Remove focus on first row of list on webpage
- Replies: 2
- Views: 8051
Re: Remove focus on first row of list on webpage
Hi Danny,
I tried that but unfortunately did not work.
I tried that but unfortunately did not work.
- Thu Oct 12, 2017 12:43 pm
- Forum: Questions & Answers
- Topic: Remove focus on first row of list on webpage
- Replies: 2
- Views: 8051
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.
Is there a way to remove this focus so it looks like this?
Is there a way to remove this focus so it looks like this?
- Wed Sep 20, 2017 4:00 pm
- Forum: Questions & Answers
- Topic: The SortOnClick Property in PRIM_LIST.String
- Replies: 3
- Views: 8498
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 ...
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 ...
- Wed Sep 20, 2017 2:46 pm
- Forum: Questions & Answers
- Topic: The SortOnClick Property in PRIM_LIST.String
- Replies: 3
- Views: 8498
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 ...
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 ...
- Wed Sep 20, 2017 2:32 pm
- Forum: Questions & Answers
- Topic: Days Elapsed since Date
- Replies: 3
- Views: 9228
Re: Days Elapsed since Date
Thanks for both your input.
I experimented and found this works:
#StkAgeDays := #DATEX.Now.Difference( #WIDT20.asdate( xYYMMDD ) )
I experimented and found this works:
#StkAgeDays := #DATEX.Now.Difference( #WIDT20.asdate( xYYMMDD ) )