topic Re: Work Areas in Application Development and Automation Discussions

Work Areas

Former Member — Thu, 19 Nov 2009 21:36:27 GMT

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 — Thu, 19 Nov 2009 21:57:45 GMT

Try assigning into string and/or use condense statement

Former Member — Thu, 19 Nov 2009 22:08:39 GMT

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

Former Member — Fri, 20 Nov 2009 04:53:23 GMT

Hi,

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