DB_DatabaseName:="Students"
DB_ODBCError:=""
DB_ODBCHandle:=ODBCOpen(WindowHandle, "DB_ODBCError", DB_DatabaseName, "", "")
SQLString:="insert into note(name) values (';mmmm)"
ODBCData:=ODBCExecute(DB_ODBCHandle, SQLString)
SQLString:="select [name]from [note] where name=';mmmm';"
ODBCData:=ODBCExecute(DB_ODBCHandle, SQLString)
ODBCClose(DB_ODBCHandle)
if ODBCData="" then
    SystemMessageBox(WindowHandle, "提交失败！", "提示信息", 64)
         else
    SystemMessageBox(WindowHandle, "提交成功！", "提示信息", 64)
    end if
数据库文件stu.mdb里有两个表np和note.
np表读写都没有问题。为什么note表只能读不能写呢？
上面的写入语句有问题吗？

***** 版主模式 ***** 该贴子是管理员从课件制作转移过来的！

DB_DatabaseName:="Students"
DB_ODBCError:=""
DB_ODBCHandle:=ODBCOpen(WindowHandle, "DB_ODBCError", DB_DatabaseName, "", "")
SQLString:="insert into note(name) values (';mmmm)"
[color=red]SQLString:="insert into note(name) values (';mmmm';)"[/color]
ODBCData:=ODBCExecute(DB_ODBCHandle, SQLString)
SQLString:="select [name]from [note] where name=';mmmm';"
ODBCData:=ODBCExecute(DB_ODBCHandle, SQLString)
ODBCClose(DB_ODBCHandle)
if ODBCData="" then
   SystemMessageBox(WindowHandle, "提交失败！", "提示信息", 64)
        else
   SystemMessageBox(WindowHandle, "提交成功！", "提示信息", 64)
   end if