LAquis 4.3 - SCADA system - Supervisory Control and Data Acquisition - SCADA .

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,bord

RowSelect

UpdateRow

UpdateCol

AcceptChange

ColClicked

RowClicked

ColText

RowText

CellText

Sort(col,tipo,col1,row1,col2,ro

ImportTxt(filename,col,row)

ExportTxt(filename,col,row,colu

PasteText(text,col1,row1,col2,r

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 n

Tags.RecordNow (row or tag name

Tags.StopRecord [(row or tag na

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

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,obj

Tags.ExecuteDriver(row,paramete

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,d

LB.LBFolder(database_name,defau

LB.Show(largura,altura,banco,ca

LB.Text

LB.Export(database_name,filecsv

LB.Combo(database_name,fields,r

LB.ListDistinct(database_name,f

LB.GetDatabaseField(response_fi

LB.FieldChange(database,filter,

Panel

Panel.Page

Panel.Page(page name or number,

Panel.FullScreen

Panel.Refresh

Panel.ChangeTagsFromPage(page,t

Panel.Popup(page)

Panel.Tag

Panel.Group

Panel.ClosePopup[(page)]

Panel.Window ( page, width, hei

Panel.ExecuteEvent(event,object

Panel.PopupTag(page number or t

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","Us

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, t

UpCase (text)

Trim (text)

Format (number or datetime, "fo

Chr (number)

Ord (character)

Len (text)

IntToHex (number [, digits])

HexToInt ( text )

IntToBin (number, digits)

Mid (text, start, end [,inserte

BytesToStr (byte1, byte2, byte3

NumberToStr (number [,bytes])

StrToNumber ( text [,start [,en

PosPos(p1,text1,text2)

DeleteString(text,start,count)

CopyString(text,start,count)

Tags.ExecuteDriver(row,paramete

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 [,en

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

Ini.WriteString(filename,sectio

Ini.ReadNumber(filename,section

Ini.WriteNumber(filename,sectio

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 bit

BitsSHR (number1, number de bit

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],] fil

Table.DeleteRow (row)

Table.InsertRow (row)

Table.Free

Table.FreeAll

Table.Col

Table.Row

Special

Input (Caption, Title, Text)

InputCombo(Title,Text,[filename

Cancelled

Ask (text)

FindFirst(find)

FindNext

FileFound

FileTimeFound

FileSizeFound

ShellExecute(filename[,s][,para

Users.check

Users.name

Users.privilege(privilege numbe

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,]

TextFile.Append ([file handle),

TextFile.Parse ([file handle],s

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

BlockWrite (file handle, pointe

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,],

Table.Open ( [row [, col],] "fi

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

=LASTFIELD(field name,id value,

=FIELDTOTAL(field name,id value

=LIST(field name,filter,date,da

=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 fie

=COMBO(text1;text2;text3,...)

=MVT(cells)

=MVJ(cells)

=MVK(cells)

=MVS(cells)

=MVR(cells)

BUTTON(text)

LISTBUTTON(text)

LISTBUTTON(text,field,database,