string ls_select_string //语法
decimal retval //返回值
int li_pos
setnull(retval)
If isnull(as_pass) then return retval
// Set up select statement using passed parameters
ls_select_string = "SELECT " + as_pass
//ls_select_string = "SELECT " + '100 + 10 / 10 - 10 * 2'
PREPARE sqlsa FROM :ls_select_string;
DECLARE dyn_cursor DYNAMIC CURSOR FOR sqlsa;
OPEN DYNAMIC dyn_cursor;
if sqlca.sqlcode < 0 then
MessageBox("DataBase Error!", sqlca.sqlerrtext + '~n' + ls_select_string)
return sqlca.sqlcode
end if
Fetch dyn_cursor into :retval;
if sqlca.sqlcode <> 0 then
MessageBox("DataBase Error", sqlca.sqlerrtext + '~n' + ls_select_string)
return sqlca.sqlcode
end if