Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5210

	People Online:
	Visitors: 445
	Members: 0
	Total: 445

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

Display Zero in Portal Form Field

5 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Woozy

Veteran Member

Posts: 709

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

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

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

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

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

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.