Who's On?

	Membership:
	Latest: cat andrews
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5215

	People Online:
	Visitors: 406
	Members: 0
	Total: 406

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

Display Zero in Portal Form Field

5 Replies

0 Subscribed to this topic

18 Subscribed to this forum

Sort:

Author

Messages

Woozy

Veteran Member

Posts: 709

New Poster

3/27/2012 5:52 PM

I have a custom form that includes a numeric field where zero is a valid value. I'd like Portal to display a zero, but it only displays a blank even though the underlying table actually shows a value of zero.

Is there a way to do this without using Design Studio?

Thanks!

Ragu Raghavan

Veteran Member

Posts: 477

New Poster

Engaged Poster

Avid Poster

Engaged Reader

Avid Reader

3/27/2012 6:56 PM

Is this 4GL code ?
Mayhe change the screenfield to alpha right justified amd have an edit in the code for numeric and then convert to numeric before saving in the DB ?

John Henley

Posts: 3364

New Poster

Engaged Reader

Avid Reader

3/27/2012 7:09 PM

You can do it with some creative CSS and JavaScript, but it would be a modification to Portal.

Woozy

Veteran Member

Posts: 709

New Poster

3/27/2012 9:47 PM

OK - thanks guys. I'm not very exited about either approach. I guess it can just be a training issue on the new program.

Thanks anyway!

Steven Gray

Advanced Member

Posts: 21

New Poster

3/31/2012 12:42 PM

If the custom form was designed in pgmdef, try using the Field Type edit value N1 or N2 in the screen definition Transaction Data section. The Workbench Manual says either of these codes will allow for the display of leading zeros.

Woozy

Veteran Member

Posts: 709

New Poster

4/2/2012 1:22 PM

Hi Steven - Yep, that's what I tried first. It seems to work in LID, but it doesn't appear to have any impact in Portal. I tried both N1 and N2 without success. Thanks for the thought, though.