11-19-2009 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
11-20-2009 4:53 AM
Hi,
Check if the field that you are using in WHERE clause for the query has type Char10
11-19-2009 9:57 PM
11-19-2009 10:08 PM
Normally it should not happen if your work area is line type of my table.
11-20-2009 4:53 AM
Hi,
Check if the field that you are using in WHERE clause for the query has type Char10