17.0 Supported Expression

ChangeEmbed("Page Name", “Object Name")

This is used to display an assigned page on the 'Page Embeding' screen.

(The object name is ‘View - Object Window - the number inside the brackets [ ]’)

(Only for Command Expression)

ChangeEmbedEx("Page Name", "Object Name", "Tag Name List")

This is used to display an assigned page as an assigned tag on the ‘Page Embeding' screen

(The object name is ‘View - Object Window - the number inside the brackets [ ]’)

(Only for Command Expression)

ClosePage ("Page Name") 

This is used to close an assigned page.

ClosePage (“URL address”)

This is used to close an assigned URL address from the screen.

(Note: A precise URL must be provided.)

OpenPage ("Page Name") 

This is used to open Popup page with assigned page.

OpenPage (“URL address ,position:top,left,width,height”)

Displays the specified URL address in a popup window.

You can specify the desired position for the popup window using ', position:'.

If ', position:' is not entered, the default position will be (0,0,1920,1080).

(Note: A precise URL must be provided.)

OpenPageEx ("Page Name", "Tag Name List")

This is used to display an assigned page as an assigned tag. (Only for Command Expression)

ReplacePage ("Page Name")

This is used to open web page with assigned page.

ReplacePage (“URL address”)

This is used to open a webpage with the assigned URL address.

(Note: A precise URL must be provided.)

ReplacePageEx ("Page Name", "Tag Name List")

This is used to open web page with assigned page as an assigned tag. (Only for Command Expression)

wcGridInsertData ("Page name.Object Name", "DATA")

This is used to add a new row to the Input/output table object.

However, please note that the data format must be entered as follows.

EX) DATA = ‘value1’,'value2’,'value3’,'value4’,'value5'

wcGridGetData ("Page name.Object Name", col, row)

This is used to inform the cell data of a Input/output table bbject. (String output)

wcGridSetData ("Page name.Object Name", col, row, data)

This is used to set up data in the specific cell of a Input/output table object.

wcGridGetRowCount ("Page name.Object Name")

This is used to inform the Row count of a Input/output table Object. (String output)

wcGridClearData ("Page name.Object Name")

Deletes data from the Input/output table.

CSqlClose ("Query Name")

The ‘Query Name’ is to be registered in SELECT Statement through the ODBC Manager. This function is used to execute a work by using Function CsqlOpen()and the functions related to various cursors. If no more work is needed, it will inform a system of finishing.

CSqlDelete ("Query Name") 

The ‘Query Name’ is to be registered in SELECT Statement through the ODBC Manager. Before this function is used, a SELECT Statement should be run by using CsqlOpen(). This function is used to delete the record that the cursor assigns at a called time from DBMS.

CSqlFirst ("Query Name") 

The ‘Query Name’ is to be registered in SELECT Statement through ODBC. Before this function is used, a SELECT Statement should be run by using CsqlOpen(). This function is used to move a current cursor to the record on the top. As the result, the field value for a new record is moved to the value of a linked tag.

CSqlGetError("Query Name") 

This is used to check whether the ODBC functions executed just before(Ex., CSqlInsert, CSqlOpen … ) were executed normally. If normally executed, 0 is returned. If other value is returned, an error occurs. The error description for each return value is as follows.

CSqlGetRecord"Query Name", Record Number 

 This is used to set up the data corresponding to an assigned record number among the records gotten by the ‘QUERY Name’ as the value of the linked tag.

CSqlGetRecordNo"Query Name" 

This is used to return the number of the Records gotten by the ‘Query Name’. 

CSqlInsert ("Query Name") 

The ‘Query Name’ is registered in SELECT Statement through the ODBC Manager. Before this function is used, a SELECT Statement should be run by using CsqlOpen().This function is used to make the tag values at a called time as the field values inked with each tag and to compose a new Record. And it is to register the Record to DBMS.

CSqlLast ("Query Name") 

The ‘Query Name’ is registered in SELECT Statement through the ODBC Manager. Before this function is used, a SELECT Statement should be run by using CsqlOpen().This function is used to move a current cursor to the last Record. At the result, the field value of a new Record is moved to the value of a linked tag.

CSqlNext ("Query Name")

 The ‘Query Name’ is registered in SELECT Statement through ODBC. Before this function is used, a SELECT Statement should be run by using CsqlOpen().This function is used to move a current cursor to the next Record. At the result, the field value of a new Record is moved to the value of a linked tag.

CSqlOpen ("Query Name")

 The ‘Query Name’ is registered in SELECT Statement through the ODBC Manager. This function is to be called before the function related to a cursor is used. Close by using Function CsqlClose() if necessary work is done. The functions related to a cursor include the reading functions for several Records gotten as the result of the execution of a SELECT sentence and the functions to delete, Insert, update and rerun the Record.

CSqlPrev ("Query Name") 

 The ‘Query Name’ is registered in SELECT Statement through the ODBC Manager. Before this function is used, a SELECT Statement should be run by using CsqlOpen().This function is used to move a current cursor to the previous Record. At the result, the field value of a new Record is moved to the value of the linked tag.

CSqlReconnect ("DBMS Name")

 This is used to reconnect with DBMS. In case of the disconnection due to unexpected reasons while DBMS is used, the CIMON is to be reconnected with DBMS.

CSqlRequery ("Query Name") 

 The ‘Query Name’ is registered in SELECT Statement through the ODBC Manager. Before this function is used, a SELECT Statement is to be run by using CsqlOpen().This function is used to rerun a corresponding SELECT Statement and to reread the Record in DBMS.

CSqlRun ("Query Name")

 The ‘Query Name’ is to be registered through the ODBC manager. This is used to run a query.

CSqlUpdate ("Query Name")

 The ‘Query Name’ is registered in SELECT Statement through the ODBC Manager. Before this function is used, a SELECT Statement is to be run by using CsqlOpen().This function is used to make the tag values at a called time as the field value linked to each tag, and to modify the Record that a cursor assigns to update this Record in DBMS.

RawSqlRun ("DBMS Name", "SQL Program" )

 The ‘DBMS Name’ is to be registered in the ODBC manager. This is used to run a query about this DBMS. The query sentence(SQL) run is to be assigned to the second parameter by using double quotation marks.

PlaySound ("SoundFile Name") 

This is used to run a sound file (wav format).

PlaySoundEx ("SoundFile Name", Number Of Repeat) 

 This is used to repeat running an assigned sound file (wav format) as much as the number of repeats.

StopSound 

 This is used to quit all the sound outputted.

StopSoundEx ("SoundFile Name") 

This is used to quit the output of an assigned sound file. 

EnableReport("Report Model Name", Execution/Stop) 

 This is used to stop or run an assigned report model.

ReportDialog 

The Print/Open Report dialog box is shown. This dialog box is used to reprint or to output the previous report file. 

(Only for Command Expression)

ReportOut ("Report Model Name") 

 An assigned report model is outputted immediately.

ReportTimeStr("Time Value", Time Format) 

 This is used to output the time for a report in a string according to time format. 

TLogVal("Tag Name", "Time Value", "Value Type") 

 This is used to output the data value for the report of an assigned tag.

AddTagEvent ("Tag Name", "Script Name")

This is used to run an assigned script whenever the value of an assigned tag is changed. 

PulseOff ("Tag Name", Pulse Width) 

This is used to Pulse-Off-output an assigned tag as much as a given pulse width (Unit: msec).

PulseOn ("Tag Name", Pulse Width )

This is used to Pulse-On-output an assigned tag as much as a given pulse width (Unit: msec). 

PulseTag ("Tag Name", Pulse Width) 

 This is used to pulse-output the value of an assigned tag as much as a given pulse width (Unit: msec).

RemoveTagEvent ("Tag Name") 

This is used to delete the tag event registered to an assigned tag. If this function is called, a script will not be run even the tag value is changed. 

TagAction ("Tag Name") 

 This is used to run the tag action registered to an assigned tag. 

ManualEntry( "Tag Name", Value) 

This is used to set tag value on UltimateAccess Web’s memory only. This function does not write to a IO device. 

FormatStr("Conversion Form", Value Type, Value) 

 This is used to display an assigned value in a string, conforming to the conversion form. 

GetCommentStr( idx, row, column) 

 This is used to string tell the CommentTable (String output) 

GetTime("Time Display String") 

 This is used to output an assigned time in second. 

RunApp ("Execution File", "Parameter") 

 This is used to run a specific application program.

ShowAlarm 

 This is used to show the "Alarm" window.

(Only for Command Expression)

ShowDatabase 

 This is used to show the "Database" window.

(Only for Command Expression)

ShowDatalog 

 This is used to show the "Data Logging" window.

(Only for Command Expression)

ShowNetStatus 

This is used to show the "Communication Status" window.

(Only for Command Expression)

ShowReport 

This is used to show the "Reports" window.

(Only for Command Expression)

ShowRunStatus 

This is used to show the "System status" monitoring window.

(Only for Command Expression)

TimeConvert(Time Value, Time Format) 

This is used to convert the assigned time value to other type according to format, and to output the result in a string.

TimeStr(Time Format) 

This is used to output a current time value in the following strings according to assigned time format. 

TimeToStr(Time Value, Time Format) 

This is used to output an assigned time value in a string according to time format. 

ProjectBackup "Backup Folder" 

This is used to back up set files in File Backup.ini through an assigned folder. The contents of File Backup.ini are set up in an assigned directory and file for Back-Up. 

ReadPrivateIni("Section", "Item", "File Name") 

This is used to read and bring the item value of an corresponding section from an assigned file.

WritePrivateIni ("Section", "Item", "Value", "File Name") 

This is used to enter a value to the item of a section corresponding to an assigned file. 

EnableDataLog ("Data Logging Model", Run(1)/Stop(0)) 

 This is used to run or stop the data logging of a corresponding data-logging model.

AlarmAck ("Tag Name")

This is used to acknowledge the alarm in an assigned tag. 

AlarmAckAll 

This is used to acknowledge the all alarms. 

AlarmSound ("Tag Name", "Sound File") 

This is used to register a sound file (Wave type) outputted when an alarm occurs in an assigned tag. 

GetAlarmCount(Alarm Level/Zone) 

This is used to inform the number of the current alarms corresponding to an alarm level or an alarm zone.

DLogVal("Tag Name", "Time Value") 

 This is used to data logging it outputs the assigned time value when it corresponds.

CommClearCount ("Device Drivers Name") 

This is used to clear an assigned device driver, station or all communication counters related to a whole system.

CommClearCount ("Device Drivers Name.Station Name" )

 This is used to clear an assigned device driver, station or all communication counters related to a whole system.

CommClearCount ("") 

This is used to clear an assigned device driver, station or all communication counters related to a whole system.

CommRxCount("Device Drivers Name") 

This is used to output the number of the tag values received from an assigned device driver, station or a whole system (Errors included)

CommRxCount("Device Name")

This is used to output the number of the tag values received from an assigned device driver, station or a whole system (Errors included)

CommRxCount("") 

This is used to output the number of the tag values received from an assigned device driver, station or a whole system (Errors included)

CommStatus("Device Drivers Name") 

This is used to output the communication status for an assigned device driver or station. If the name of a device driver is not assigned, the communication status for a whole system will be outputted.  

CommStatus("Device Drivers Name.Station Name")

 This is used to output the number of the tag values written in an assigned device driver, station or a whole system. (Errors included)

CommStatus("")

This is used to output the communication status for an assigned device driver or station. If the name of a device driver is not assigned, the communication status for a whole system will be outputted. 

CommTxCount("Device Drivers Name")

This is used to output the number of the tag values written in an assigned device driver, station or a whole system. (Errors included)

CommTxCount("Device Drivers Name.Station Name")

This is used to output the number of the tag values written in an assigned device driver, station or a whole system. (Errors included)

CommTxCount("")

This is used to output the number of the tag values written in an assigned device driver, station or a whole system. (Errors included)

CommTxErrCount("Device Drivers Name")

This is used to output the number of the sending errors in the number of tag values written in an assigned device driver, station or a whole system.

CommTxErrCount("Device Drivers Name.Station Name") 

This is used to output the number of the sending errors in the number of tag values written in an assigned device driver, station or a whole system. 

CommTxErrCount("") 

This is used to output the number of the sending errors in the number of tag values written in an assigned device driver, station or a whole system.. 

EnableDevice ("Device Name", Run(1)/Stop(0)) 

This is used to run or stop the communication for an assigned drive or station. 

ModemConnect ("Device Name", "Tel No", "Modem Initialization Command") 

This is used to link a corresponding device to a modem through an assigned telephone number by using modem initialization command.

ModemDisconnect ("Device Name") 

 This is used to release the modem link to a corresponding device.

DriverCommand ("Station Name", Command, "Parameter") 

This is used to control the driver of a specific I/O device by the command language and parameter value of a corresponding driver. 

GetLineStatus(Line Number) 

This is used to inform the status of each line in case of network redundancy.

GetNodeStatus("Node Name") 

This is used to inform the link status of an assigned network node. If node status is normal, 1 will be outputted. Otherwise, 0 will be outputted. 

GetNodeType() 

This is used to output in string as follows according to the current action mode of a system.

GetServerName(Server Name)

This is used to output the name for an assigned server in string.

IsActiveServer("Node Name") 

This outputs 1, if an assigned node is active server. Otherwise, it outputs 0. 

SwapServer() 

In case of redundancy system, active system and back-up system will be  switched each other. 

RecipeGetData("Model Name", "Field Name") 

This is used to bring the field value of a corresponding recipe model in current recipe memory. To use this function to a command expression, the data value brought from A1 = RecipeGetData(" Process 1", "Calcium") is to be matched with the corresponding tag(Real, Virtual tag) saved. 

RecipeGetError() 

This is used to get recipe error count. 

RecipeSetData ("Model Name", "Field Name", Description) 

This is used to set specific field value  

DbInsert("Log DB Model Name") 

This is used to Save the moment by reading the tag value registered in the LogDB model 

DbSetFindTime " Log DB Model Name",Start Time, End Time 

This is used to Set the time to search

DbSetFindTimeStr "Log DB Model Name","Start Time String Variable","End Time String Variable" 

This is used to Set the time to search.

DbSetFindFilter("Log DB Model Name","Conditional Expression") 

This is used to Sets the conditions for searching. Returns 0 if the conditional expression is valid, or non-zero if the conditional expression is invalid. For error values, see the error table 

DbFindRun("Log DB Model Name") 

This is used to performs a search with the search conditions set through DbSetFindTimeStr and DbSetFindFilter. If the search is successful, the return value is 0.

DbFindCount("Log DB Model Name") 

Function that tells you how many records were retrieved after a DbFindRun. The return value is the number of records. 

DbFindFirstItem("Log DB Model Name") 

This is used to Moves the pointer to the earliest record in the retrieved records. The return value is the order of the records. 

DbFindLastItem("Log DB Model Name") 

This is used to Moves the pointer to the last record in the retrieved records. The return value is the order of the records. 

DbFindNextItem("Log DB Model Name") 

This is used to Moves from the current record pointer to the next record in the sequence. The return value is the sequence of records. 

DbFindPrevItem("Log DB Model Name") 

This is used to Moves from the current record pointer to the record in the previous order. The return value is the order of the records. 

DbFindItemData("Log DB Model Name","Item Name") 

This is used to Gets the value of the item at the current record pointer.

MinReportVal("Tag Name","Time Value","Value Type") 

This is used to get values stored in the minute-by-minute report.

AddUserEventLog ("string variable") 

This is used to set data in User event logging.

RunScript "Script Name" 

This is used to Run the specified script.

RunScriptEx "Script Name", Option, Parameter 

This is used toRuns the specified script, passing in parameters.

StopScript "Script Name" 

This is used to Stops the specified script.

GetParameter() 

This is used to get the parameters of the function passed to RunScriptEx.