Progress Format Overlay

D

dkdini

New Member
Hi all,
Can anyone help on this..??
Actually Im using progress 4gl for QAD ERP.
Im suppose update some of my table field's value which has the default format ">>>,>>>,9999.99" with my new values of format ">>>,>>>,>>>,99999.99<<<" .
Any trigger syntax is there to update these type of value.??
I can able to update using trigger concept, but while Retrieving its giving "** format error cannont display value".

Not only customized table, where we can alter the table .df, but Existing QAD screens also we facing this issue.(but we cant alter the QAD tables).

Please anyone support on this..


Dinesh S.

QAD Development Team,
Thirdware.
 
I'll move this to the relevant forum, but I'm not entirely clear what your problem is I'm afraid.
 
Cringer,
We are using QAD MFG/PRO - EB2 SLES 11
PROGRESS Procedure Editor
Release 10.2B04

The problem is we are suppose to change the Standard QAD Amount fields format from ">>>,>>>,9999.99" (General Format) to ">>>,>>>,>>>,999,999.99999".

for eg:
{mfdtitle.i}
ON ENTRY ANYWHERE
DO:
IF SELF:NAME = "ckdamt" AND SELF:FRAME-NAME = "d" THEN DO:
ASSIGN SELF:FORMAT = "->>>,>>>,>>>,>>>,999.99".
END.
END.
PAUSE 0 NO-MESSAGE.
Execname = "apmcmt.p".
{gprun.i ""apmcmt.p""}

I have used the above syntax to increase the amount field format in "Payment manual check" Screen.
And i cant able to increase all fields in this screen, only few i can able to fix.
Hope you got my requirement.

Problem im facing is,
1. Screen width i cant able to increase, bcoz any QAD maintenance are with 80 columns max.
2. Getting format error, bcoz i can able to update 15,4 decimal value into 10,2 decimal field. but cant retrive using the QAD reports, it giving

** Value 9999999999999999 cannot be displayed using ->>>>,>>>,>>9.99. (74) error.

Also heard the we can give a pop_up screen to get the update of 15,4 decimal value and thereby using OVERLAY concept to hide the above errror screen using new screen.
Explain me about OVERLAY.????
Kindly support, If you got me....

Thanks
Dinesh S.

 
This sounds like madness. Is this how QAD suggests you customize amount fields?

Patching in alternative field formats on entry of any field sounds clever, but does not work since you are too late. You need to adjust the format phrase of the variable being used. To help you further into your corner, you could catch error 74 and then adjust the format by walking the widget tree - but by that time you've already lost the original value and only have ??? to work with.

Also beware with how many decimals your amount fields are defined. If they are defined with 2 decimals, extending the field format to allow 4 decimals will still only store two decimals.

Code: 
DEF VAR de AS DECIMAL FORMAT ">>>,>>9.9999" DECIMALS 2.


UPDATE de.


MESSAGE de VIEW-AS ALERT-BOX.

The only real solution is to add your own FORMAT phrase to all references - I have no idea how much source code QAD provides for customization.

BTW - love the Thirdware wikipedia page - "Thirdware has sold stuff to over..." - the above does indeed sound like 'stuff'.
 
You must log in or register to reply here.
Back
Top