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