Description Zhi Zhu 2011-11-01 04:36:24 EDT

The generated SQW for statement:
   open rs from ds for aCust using(aCust.CUSTOMER_ID);

is:
   SELECT CUSTOMER_ID, RTRIM(FIRST_NAME), RTRIM(LAST_NAME), RTRIM(PASSWORD), RTRIM(PHONE), RTRIM(EMAIL_ADDRESS), RTRIM(STREET), RTRIM(APARTMENT), RTRIM(CITY), RTRIM(STATE), RTRIM(POSTALCODE), RTRIM(DIRECTIONS) FROM CUSTOMER"

aCust definition:
record CUSTOMER type Entity{@table{name = "CUSTOMER"}}
    CUSTOMER_ID int{@id};
    FIRST_NAME string?;
    LAST_NAME string?;
    PASSWORD string?;
    PHONE string?;
    EMAIL_ADDRESS string?;
    STREET string?;
    APARTMENT string?;
    CITY string?;
    STATE string?;
    POSTALCODE string?;
    DIRECTIONS string?;
end

no where clause in this case