iFIX经典问题问答.docVIP

iFIX经典问题问答 1:iFIX中如何使用vba开启和停止wsqlodc和alarmsODBC？DescriptionThe?ability?to?stop?or?start?the?SQL?task,?wsqlodc,?and?to?pause?or?continue?the?alarms?to?ODBC?task?used?to?only?be?available?by?launching?Mission?Control?and?manually?controlling?them.?The?ability?to?perform?this?control?programmatically?using?VBA?was?added?as?part?of?a?SIM?for?iFix?2.5.?The?function?calls?to?allow?this?are?not?widely?documented?and?are?shown?below:?-ResolutionDeclare?Function?TurnOnSqlTask?Lib?missionvba?(ByVal?cmd$)?As?LongTurns?on?a?SQL?task.??The?cmd$?parameter?is?the?command?line?passed?to?the?SQL?taskReturn?of?0?is?a?success.??Current?logged?in?user?must?have?security?rights?to?turnon/off?SAC.??If?a?non-zero?error?code?is?returned,?you?can?use?the?err2strutility?in?the?fix?base?directory?to?translate?the?error?to?a?stringDeclare?Function?TurnOffSqlTask?Lib?missionvba?()?As?LongTurns?off?a?SQL?task.??Return?of?0?is?a?success.??Current?logged?in?user?musthave?security?rights?to?turn?on/off?SAC.??If?a?non-zero?error?code?is?returned,you?can?use?the?err2str?utility?in?the?fix?base?directory?to?translate?the?error?to?a?stringDeclare?Function?PauseAlarmODBC?Lib?missionvba?()?As?LongPauses?the?AlarmODBC?task.??Return?of?0?is?a?success.??Current?logged?in?user?does?NOThave?to?have?security?rights.This?function?will?execute?regardless?of?the?Allow?Operator?to?Pause?Alarm?LoggingSetting?found?in?the?iFIX?ODBC?Alarm?Service?Configurator?of?the?System?ConfigurationUtility.Private?Declare?Function?ContinueAlarmODBC?Lib?missionvba?()?As?LongResumes?the?AlarmODBC?task.??Return?of?0?is?a?success.??Current?logged?in?user?does?NOThave?to?have?security?rights.This?function?will?execute?regardless?of?the?Allow?Operator?to?Pause?Alarm?LoggingSetting?found?in?the?iFIX?ODBC?Alarm?Service?Configurator?of?the?System?ConfigurationUtility.All?of?these?functions?will?block?until?the?request?is?completed.2：iFIX如何使用vba开启和停止基于时间和事件的调度？Description：This?solution?shows?