Download CIMPLICITY HMI Program Editor Operation Manual

Data types
Boolean
Data type representing True of False values
Currency
Data type used to hold monitary values
Date
Data type used to hold dates and times
Double
Data type used to hold real number with 15-16
digits of precision
Integer
Data type used to hold whole numbers with 4
digits of precision
Long
Data type used to hold whole numbers with 10
digits of precision
Object
Data type used to hold OLE automation objects
Single
Data type used to hold real number with 7 digits
of precision
String
Data type used to hold sequences of characters
Variant
Data type that holds a number, string, or OLE
automation objects
Database
SQLBind
Specify where to place results with SQLRetrieve
SQLClose
Close a connection to a database
SQLError
Return error information when an SQL function
fails
SQLExecQuery
Execute a query on a database
SQLGetSchema
Return information about the structure of a
database
SQLOpen
Establishes a connection with a database
SQLRequest
Run a query on a database
SQLRetrieve
Retrieve all or part of a query
SQLRetrieveToFile
Retrieve all or part of a query, placing results in a
file
Date/time
GFK-1305D
Date, Date$ (functions)
Return the current date
Date, Date$ (statements)
Change the system date
DateAdd
Add a number of date intervals to a date
DateDiff
Subtract a number of date intervals from a date
DatePart
Return a portion of a date
DateSerial
Assemble a date from date parts
DateValue
Convert a string to a date
Introduction
1-7