这个行么 动态建立datastore as_table传你临时表表名
datastore lds_i,lds_i_1
lds_i = CREATE datastore
lds_i_1 = CREATE datastore
ls_sql = "select "+as_keycolumn+","+as_valuecolumn+" from "+as_table+" where "+as_upkeycolumn+"='"+as_upkeyvalue+"'" + " order by " + as_keycolumn
ls_syntax = sqlca.SyntaxFromSQL(ls_sql,'style(type=grid)',ls_error)
IF Len(ls_error) > 0 THEN
RETURN 0
ELSE
ls_error = ''
lds_i.Create(ls_syntax,ls_error)
IF Len(ls_error) > 0 THEN
RETURN 0
END IF
lds_i.SetTransObject(sqlca)
lds_i.Retrieve()
int j
j = lds_i.RowCount( )
END IF