2009 Nov 19 9:36 PM
The following code initializes a component of my
work area called field_1. But the field is not compacted,
as I would expect. Instead it contains spaces, meaning
that I cannot simply pass it to a SQL statement without
first removing the blank spaces.
READ TABLE myTable INDEX 1 INTO myWorkArea.
myTable-field_1 = "ABC" --- Character length 10
myWorkArea-field_1 = " ABC ". -- Character length 10
2009 Nov 20 4:53 AM
Hi,
Check if the field that you are using in WHERE clause for the query has type Char10
2009 Nov 19 9:57 PM
Try assigning into string and/or use condense statement
2009 Nov 19 10:08 PM
Normally it should not happen if your work area is line type of my table.
Bluesky
