国家儿童医学中心(上海) | 上海交通大学医学院附属上海儿童医学中心 | 心脏中心 官方知识平台

更改ICU导入数据命令

陆医生
📅 2009-09-18 · 👁 12 次浏览 · 💬 4 条回复

Import("verify",[%datapool%],"数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And if(countfor("verify","ID", "  " ,"") >= 1,Import("数据库",[%datapool%],"数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And CloseWindow() And OpenGrid("数据库",1) And move(rows,1) And CloseWindow() And AddRow("ICU","ID",[数据库!ID]) And OpenGrid("ICU") And OpenWindow(1,(screenwidth - 1022) / 2,(screenheight - 766) / 2) And move(rows,1) ,MsgBox("           ----系统提示----" + Char(13)+ Char(13) + "抱歉,系统没有找到此例患者,请核对信息!",1,3))
修改为:
CopyFile([%datapool%],docdir+"temp.egd") And Import("verify",docdir+"temp.egd","数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And if(countfor("verify","ID", "  " ,"") >= 1,Import("数据库",docdir+"temp.egd","数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And CloseWindow() And OpenGrid("数据库",1) And move(rows,1) And CloseWindow() And AddRow("ICU","ID",[数据库!ID]) And OpenGrid("ICU") And OpenWindow(1,(screenwidth - 1022) / 2,(screenheight - 766) / 2) And move(rows,1) ,MsgBox("           ----系统提示----" + Char(13)+ Char(13) + "抱歉,系统没有找到此例患者,请核对信息!",1,3))
因为查询数据库命令里面频繁用到import命令,这样可能会导致文件损坏。

全部回复 (4)

陆医生 会员
📅 2009-09-18

Import("verify",[%datapool%],"数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And if(countfor("verify","ID", "  " ,"") >= 1,Import("数据库",[%datapool%],"数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And CloseWindow() And OpenGrid("数据库",1) And move(rows,1) And CloseWindow() And AddRow("ICU","ID",[数据库!ID]) And OpenGrid("ICU") And OpenWindow(1,(screenwidth - 1022) / 2,(screenheight - 766) / 2) And move(rows,1) ,MsgBox("           ----系统提示----" + Char(13)+ Char(13) + "抱歉,系统没有找到此例患者,请核对信息!",1,3))
修改为:
CopyFile([%datapool%],docdir+"temp.egd") And Import("verify",docdir+"temp.egd","数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And if(countfor("verify","ID", "  " ,"") >= 1,Import("数据库",docdir+"temp.egd","数据库","888","住院号","=",[%住院号%],"手术日期", "=" ,[%手术日期%]) And CloseWindow() And OpenGrid("数据库",1) And move(rows,1) And CloseWindow() And AddRow("ICU","ID",[数据库!ID]) And OpenGrid("ICU") And OpenWindow(1,(screenwidth - 1022) / 2,(screenheight - 766) / 2) And move(rows,1) ,MsgBox("           ----系统提示----" + Char(13)+ Char(13) + "抱歉,系统没有找到此例患者,请核对信息!",1,3))
因为查询数据库命令里面频繁用到import命令,这样可能会导致文件损坏。
陆医生 会员
📅 2009-09-18
wincatcher 会员
📅 2009-09-18
明白了,就是先拷贝出来的意思。
问题是有时候外科录入数据时也会发生同样的问题。应该还有其他原因吧。
陆医生 会员
📅 2009-09-19
嗯,因为目前的系统使用了import 和export这两个命令,我现在极力避免通过网络使用import命令,但export命令似乎无法避免,从理论上来说这个问题一定是能够得到解决的,不过现在既然公司在做,我就失去解决这个问题的动力了。
LYF 会员
📅 2009-09-24
恩,看一下,路过留名了

✏️ 写回复

登录后即可回复

👤 用户信息

加载中…