T
Thiru Malai
Guest
I have written a simple query but want to show blank value to integer field in temp table. As you know if there is no data in integer field then 0 is the default value but our client says it should be blank instead of default value 0.
DEFINE TEMP-TABLE tt_data
FIELD CarColour AS CHARACTER
FIELD Qty AS INTEGER.
FOR EACH <db> NO-LOCK WHERE <db.field> = "White Car" AND <db.field> = "Red Car":
DISPLAY <db.field1> <db.field2>.
END.
/* Note <db.field1> is CHARACTER <db.field2> is INTEGER */
/* DISPLAYED VALUE IS */
WHITE 0 /* There is no qty for this white car so its showing default value 0 */
RED 100
So when I store these data to temp table White car QTY should be blank instead of 0.
Note - I cannot change Temp-Table Field Type.
Continue reading...
DEFINE TEMP-TABLE tt_data
FIELD CarColour AS CHARACTER
FIELD Qty AS INTEGER.
FOR EACH <db> NO-LOCK WHERE <db.field> = "White Car" AND <db.field> = "Red Car":
DISPLAY <db.field1> <db.field2>.
END.
/* Note <db.field1> is CHARACTER <db.field2> is INTEGER */
/* DISPLAYED VALUE IS */
WHITE 0 /* There is no qty for this white car so its showing default value 0 */
RED 100
So when I store these data to temp table White car QTY should be blank instead of 0.
Note - I cannot change Temp-Table Field Type.
Continue reading...