例如
查询表 select * from table(这个表字段以后还可能会增加)
我需要写一个函数,输入参数: 行号 和 字段名
然后返回值
求大神指导!!
------解决方案--------------------
用动态SQL搞定
------解决方案--------------------
string ERRORS, sql_syntax
string presentation_str, dwsyntax_str
sql_syntax = "SELECT * from tablename "
presentation_str = "style(type=grid)"
dwsyntax_str = SQLCA.SyntaxFromSQL(sql_syntax, &
presentation_str, ERRORS)
IF Len(ERRORS) > 0 THEN
MessageBox("Caution", &
"SyntaxFromSQL caused these errors: " + ERRORS)
RETURN
END IF
dw_1.Create( dwsyntax_str, ERRORS)
IF Len(ERRORS) > 0 THEN
MessageBox("Caution", &
"Create cause these errors: " + ERRORS)
RETURN
END IF