LAquis 4.1 - Supervisory Control and data acquisition PLC HMI SCADA system: SCADA software .

Command script:




Reports
Cells(col,row)
CellsN(col,row)
ColCount
RowCount
ColWidths(col)
RowHeights(row)
Col
Row
ClearSheet(col1,row1,col2,row2)
ClearFormat(col1,row1,col2,row2)
DeleteRow(row)
InsertCol(col)
InsertRow(row)
AlwaysDraw
Refresh
NoCalculation
Calculate
TextWidth(texto)
CellsName(name)
CellsNName(name)
Color(col,row)
Font.Color(col,row)
Font.Size(col,row)
Font.Bold(col,row)
Format(col,row)
Alignment(col,row)
Locked(col,row)
Calendar(col,row)
Formula(col,row)
Border(col1,row1,col2,row2,borde,color)
RowSelect
UpdateRow
UpdateCol
AcceptChange
ColClicked
RowClicked
ColText
RowText
CellText
Sort(col,tipo,col1,row1,col2,row2)
ImportTxt(filename,col,row)
ExportTxt(filename,col,row,columns,rows)
PasteText(text,col1,row1,col2,row2)
UnMerge(col1,row1,col2,row2)
UnMergeAll
Merge(col1,row1,col2,row2)
Button
LdbCount
LdbThisLine(row)
LdbCell("nomedocampo",row)
LdbCellN("nomedocampo",row)
Tags
Tags.Count
Tags.GroupsCount
Tags.Group
Tags.Group[(groupnumber)]
Tags.Port
Tags.StartRecord [(row or tag name or group name)]
Tags.RecordNow (row or tag name or group name)
Tags.StopRecord [(row or tag name or group name)]
Tags.Update (row or tag name)
Tags.Recording (row or tag name)
Tags.TagName(row)
Tags.TagRow(tagname)
Tags.RowWhoseName(tagname)
Tags.On (row or name)
Tags.UpdateDatabaseTags(tag or group name)
Tags.Row
Tags.Save (filename)
Tags.Play [(row or name)]
Tags.Pause [(row or name)]
Tags.PlayOnly (row or name)
Tags.CurrentRow
Tags.SelectedDatabase
Tags.Parent( row )
Tags.ChildsCount( row )
Tags.Indent( row )
Tags.ExecuteEvent(eventname,objectname)
Tags.ExecuteDriver(row,parameter)
Tags.ConfigPortCurrentScanning
Tags.TagIDName
Tags.ChangeOnlyIfDifferent
Tags.Num (column name,row)
Tags.Text (column name,row)
Tags.AlarmCount[(group)]
Tags.AlarmTag[(item,group)]
Specific tags
Tag("tag name")
Tag$("tag name")
Tag()
Tag$()
Tag(row)
Tag$(row)
Report Grid
Grid.Cells(x,y)
Grid.CellsN(x,y)
Grid.Col
Grid.Row
Grid.Calculate
Grid.Begin(filename)
Grid.Show(x,y[,z])
Grid.Open(LGX_filename[,x,y])
Grid.Print
Grid.PrintPDF("pdf_file_name")
Database
LB.Data
LB.Open(database_name)
LB.DatabaseHandle(database_name)
LB.Filter(criteria)
LB.RecordCount
LB.Pos
LB.New
LB.Read
LB.Save
LB.Fields(field_name)
LB.FieldsN(field_name)
LB.Title(field_name)
LB.Type(field_name)
LB.Format(field_name)
LB.FieldCount
LB.FieldName(index)
LB.Sort(field_name)
LB.CloseDatabase(database_name)
LB.Close
LB.LBTable(database_name,text,date)
LB.LBFolder(database_name,defaultfolder)
LB.Show(largura,altura,banco,campos,alterar,adicionar,imprimir,utilizarpesquisa)
LB.Text
LB.Export(database_name,filecsv)
LB.Combo(database_name,fields,return_field[,x,y])
LB.ListDistinct(database_name,field,date1,date2)
LB.GetDatabaseField(response_field,database_name,field,value)
LB.FieldChange(database,filter,field,value[,date])
Panel
Panel.Page
Panel.Page(page name or number,tag or group name)
Panel.FullScreen
Panel.Refresh
Panel.ChangeTagsFromPage(page,tag or group name)
Panel.Popup(page)
Panel.Tag
Panel.Group
Panel.ClosePopup[(page)]
Panel.Window ( page, width, height )
Panel.ExecuteEvent(event,object)
Panel.PopupTag(page number or tagname,"Tag or Group"[,x1,y1,width,height])
Panel.CloseAllPopups
Panel.Title
App
App.APLPath
App.Path
App.Close
App.Minimize
App.Restore
App.Stop
App.Title
Global

Event
TCP
TCP.Connect(ip,port)
TCP.Communicate(text)
TCP.Disconnect
TCP.SendEmail("SMTP server","User","Password","email Origin","email Destiny","Subject","Text","Attachment file name")
General
Dim {string variable}
If
Then
If Then
ElseIf
Else
End If
Goto
For = to
Next
End
Function
End Function
Exit Function
Declare
GoSub
Return
Commands
Commands
Execute(filename)
F1G(x1,y1,x2,y2,x)
Rnd
Randomize
Int (x)
Mod (number1,number2)
Frac (x)
Round (x)
Power (base, exponent)
Exp (x)
Exp10 (x)
Log (x)
Ln (x)
Cos (x)
Sin (x)
PI
GetDecimals(x)
Timer
Timer
Timer.Reset
Timer.NAME
Timer.NAME.Reset
Clock
Clock.Reset
Clock.NAME
Clock.NAME.Reset
Now
DateToNumber(day,month,year)
Delay(n miliseconds)
Sleep(n milissegundos)
Day(datetime)
Month(datetime)
Year(datetime)
Hour(datetime)
Minute(datetime)
Second(datetime)
MiliSecond(datetime)
WeekDay(datetime)
StrToTime(datetimetext)
TimeToStr(datetime)
FastTimer
WindowsTimer
TimerName(nome)
ClockName(nome)
Boolean
Text
CStr (number)
Val (text)
InStr (variable, text)
InStrPos (startpos, variable, text)
UpCase (text)
Trim (text)
Format (number or datetime, "format")
Chr (number)
Ord (character)
Len (text)
IntToHex (number [, digits])
HexToInt ( text )
IntToBin (number, digits)
Mid (text, start, end [,insertext] )
BytesToStr (byte1, byte2, byte3, ...)
NumberToStr (number [,bytes])
StrToNumber ( text [,start [,end] ] )
PosPos(p1,text1,text2)
DeleteString(text,start,count)
CopyString(text,start,count)
Tags.ExecuteDriver(row,parameter)
WriteCom (text)
ReadCom (n)
WriteReadCom (s,n[,try][,eos])
OpenCom
CloseCom
ConfCom(conf)
Port
Command
Parameter
IO.Port ( port )
BytesToStr (byte1, byte2, byte3, ...)
NumberToStr (number [,bytes])
StrToNumber ( text [,start [,end] ] )
FloatToStr (number[,size])
StrToFloat (texto[,size])
DefaultSettings
OpenDevice(name)
CloseDevice(name)
CloseAllDevices
DeviceID([name])
Purge[(type)]
IsError(tag value)
MsgBox(text)
Key
INI
Ini.ReadString(filename,section,field,defaulttext)
Ini.WriteString(filename,section,field,text)
Ini.ReadNumber(filename,section,field,defaultnumber)
Ini.WriteNumber(filename,section,field,number)
App gen
App.Path
Bit
Bytes (number, x )
Bits (number, bit [,bit2] )
BitsAND (number1, number2)
BitsOR (number1, number2)
BitsXOR (number1, number2)
BitsSHL (number1, number de bits [, Type])
BitsSHR (number1, number de bits [, Type])
BitsNOT (number1 [, Type])
Low (number)
High (number)
Swap (number)
Gauge
File
FileExists(filename)
Kill(filename)
Table
Table.Name
Table.Title
Table.ColCount
Table.RowCount
Table.FixedCols
Table.FixedRows
Table.Cells (col, row)
Table.TextColor (col, row)
Table.Color (col, row)
Table.ColWidths
Table.RowHeights
Table.Visible
Table.SelectCursor
Table.ReadOnly
Table.Clean
Table.Show [( [x1, y1,], dx, dy )]
Table.Save ( filename )
Table.Open ( [row [, col],] filename, [adjustrows] )
Table.DeleteRow (row)
Table.InsertRow (row)
Table.Free
Table.FreeAll
Table.Col
Table.Row
Special
Input (Caption, Title, Text)
InputCombo(Title,Text,[filename][l1,l2,l3,...])
Cancelled
Ask (text)
FindFirst(find)
FindNext
FileFound
FileTimeFound
FileSizeFound
ShellExecute(filename[,s][,param])
Users.check
Users.name
Users.privilege(privilege number)
Global.NAME
Vector.NAME (n)
Matrix.NAME (x,y)
Vector.NAME.Free
Matrix.NAME.Free
StoreValue ( number, "name" )
RestoreValue ( "name" )
ExistsValue( "name" )
ClearValue ( "name" )
FreeStoredValues
Text File
TextFile.Open ("file name")
TextFile.Close [(file handle)]
TextFile.Eof ([file handle])
TextFile.Read ([file handle])
TextFile.Write ([file handle,] text)
TextFile.Append ([file handle),] text)
TextFile.Parse ([file handle],string1,string2)
Dialog
Dialog.Open(filename [,filter])
Dialog.Save(filename [,filter])
Specials
Open (filename)
Close (file handle)
Size (file handle)
Position (file handle)
BlockRead (file handle, pointer, size )
BlockWrite (file handle, pointer, size )
Read (file handle)
Write (file handle,byte)
Table
Table.Name
Table.Title
Table.Textcolor (col, row)
Table.Color (col, row)
Table.Show [( [x1, y1,], dx, dy )]
Table.ShowNormal [( [x1, y1,], dx, dy )]
Table.Open ( [row [, col],] "filename", [adjustrows] )
Table.Property("property name")
Table.Bitmap
Table.Clip
Table.Event
Table.Proportional
Brush
Font
Pen
Report formulas
=TAG(tag name or row)
=TAG(column name",tag name)
=TITLE(tag name)
=FIELD(field name,id value,date,database,id field,extra filter)
=LASTFIELD(field name,id value,date,database,id field,extra filter)
=FIELDTOTAL(field name,id value,date,database,id field,extra filter)
=LIST(field name,filter,date,database,maximum,dateto,id field,sampling)Report spreadsheet:
=TEXT(cell)
=TEXT(cell1;cell2;cell3,...)
=CONCATENATE(cell1;cell2;cell3,...)
=AVERAGE(cells)
=SUM(cells)
=COUNT(cells)
=SDEV(cells)
=MAXIMUM(cells)
=MINIMUM(cells)
=TAGTEXT(tag name or row)
=TAGGROUP(tag name;optional field)
=COMBO(text1;text2;text3,...)
=MVT(cells)
=MVJ(cells)
=MVK(cells)
=MVS(cells)
=MVR(cells)
BUTTON(text)
LISTBUTTON(text)
LISTBUTTON(text,field,database,date1,date2)