文档更改根据库表表格生成DML语句
由 Qiongpan Ke 于 2024-07-03 最后修改
修改评论:
该版本没有评论
摘要
细节
- 页面属性
-
- 内容
-
... ... @@ -45,11 +45,13 @@ 45 45 dbins = "insert into " & tableName & " (" & Replace(dbval(titleCells), "'", "") & ") values (" & dbval(valueCells) & ");" 46 46 End Function 47 47 48 + 48 48 ' 获取数据行对应的 DML 删除语句。 49 49 Function dbdel(tableName As String, primaryKey As String, primaryValue As String) As String 50 50 dbdel = dbval(primaryValue) 51 51 dbdel = "delete from " & tableName & " where " & primaryKey & IIf(dbdel = "null", " is ", " = ") & dbdel & ";" 52 52 End Function 54 + 53 53 {{/code}} 54 54 55 55 = 使用示例 =
- USER_INFO.xlsm
-
- 大小
-
... ... @@ -1,1 +1,1 @@ 1 - 20.1 KB1 +19.7 KB - 内容