|
楼主 |
发表于 2011-1-27 16:31:17
|
显示全部楼层
writepath_room = function (area,zone,room,path_go,path_back,id_extra,id_plus) --把记录的特定房间路径写入数据库path3_room
assert (package.loadlib (GetInfo(56).."odbc.dll","luaopen_luasqlodbc")) ()
env = assert (luasql.odbc())
con = assert (env:connect ("Pkuxkx-Scyllane","",""))
local str = "INSERT INTO [path3_room]([area],[zone],[room],[path_go],[path_back],[id_extra],[id_plus]) VALUES('"..area.."','"..zone.."','"..room.."','"..path_go.."','"..path_back.."','"..id_extra.."','"..id_plus.."')"
cur = assert (con:execute (str))
--cur:close()
con:close()
env:close()
Note(" 此记录已写入数据库path3_room。")
Execute(GetVariable("path_make_temp_back_plus").."(ok)")
end
上面是我脚本里面的一段代码,其他还有几个函数查询和写入ACCESS的跟这个差不多类似。以前用的时候一直没出现什么客户端工作过多的问题,昨天在公司和家里电脑上先后出现那毛病,想半天也没想明白到底是什么导致的……请各位大侠帮忙看看,拜谢! |
|