Skip to Content
0
Former Member
Dec 27, 2007 at 07:33 AM

Select Max problem

37 Views

Hi currently i have this sql error problem which i do not know how to solve. below are my codes. I think there is something wrong with my sql statement.

DATA: M_TABLE TYPE TABNAME,

COLUMN_FIELD(14) TYPE C,

VALUE2 TYPE P DECIMAL 1.

M_TABLE = 'ZTABLE'.

COLUMN_FIELD = 'GPA'."example 2.1

SELECT MAX( COLUMN_FIELD ) FROM (M_TABLE) INTO VALUE2.

============================================

After solving this problem, i have another problem. Now my column_field 'GPA' is to decimal 1 as i have declared. But if i need to do it in dynamic example if another column field is money which i do not know the decimal will be placing at where, how should i declare it?