Work Areas

[Former Member]

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

[Former Member]

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

[former_member191735]

Try assigning into string and/or use condense statement

[Former Member]

Normally it should not happen if your work area is line type of my table.

[Former Member]

Hi,

Check if the field that you are using in WHERE clause for the query has type Char10