Displaying unknown/NULL values

G

gkokmdam

New Member
How can I change the way Progress 4GL clients display a NULL/Unknown value? I keep getting ? on the screen, but my users don't understand. I'm talking about this because we moved our db backend to be generated using SQL iso 4GL and there you just don't use blank strings but NULL values for un-filled-in fields.
Now I want to change the behaviour of all of my window-procedures to display these NULL/unknown fields to display a empty string.
Any suggestions?
Gerke
 
If you are using sql to get the data use nvl function, and if you are using 4gl then you can change the initial value for the fields or change the code to display blank instead of ?.

HTH
V

gkokmdam said:
How can I change the way Progress 4GL clients display a NULL/Unknown value? I keep getting ? on the screen, but my users don't understand. I'm talking about this because we moved our db backend to be generated using SQL iso 4GL and there you just don't use blank strings but NULL values for un-filled-in fields.
Now I want to change the behaviour of all of my window-procedures to display these NULL/unknown fields to display a empty string.
Any suggestions?
Gerke
Click to expand...
 
Extra information on the problem

The situation is like this: We have a large code base(4GL). And we changed the backend to be generated by the SQL engine.
Now because of the constraints used in SQL, we want to change all blacks to NULL values. But this breaks all exsisting 4GL-code. I would like there to be a option to change the behavior of displaying unknown/NULL values.
Thanks for the reply, anyway. I do however need a deeper solution. (changing 1700 files, without having to go through them all :-) )
 
You must log in or register to reply here.
Back
Top