易语言sql语句生成模块

易语言 2020-08-19 18:00:05

易语言sql语句生成模块

.判断开始 (_Action = “INSERT”)
.计次循环首 (取数组成员数 (drow), i)
fields = fields + drow [i].key + “,”
values = values + drow [i].value + “,”
.计次循环尾 ()
_Rows = “(” + getColumn (fields) + “) VALUES (” + getValues (values) + “)”
.判断 (_Action = “UPDATE”)
.计次循环首 (取数组成员数 (drow), i)
setstr = setstr + getColumn (drow [i].key) + “ = ” + getValues (drow [i].value) + “,”
.计次循环尾 ()
_Rows = TrimEnd (_Rows, “,”)