CONTROL
- Introduction to CTRL
- CONTROL Classes
- Types of Control Functions
- CONTROL graphics
- CONTROL Functions
  - Funtions A
  - Funtions B
  - Funtions C
  - Funtions D
  - Functions E
  - Functions F
  - Functions G
  - Functions H
  - Functions I
  - Functions J
  - Functions K
  - Functions L
  - Functions M
  - Functions N
  - Functions O
  - Functions P
  - Functions Q
  - Functions R
    - rad2deg()
      Converts an angle from a radian measure into degrees.
    - rand()
      Calculates a sequence of integer pseudo random numbers.
    - readDictionary()
      Appends the entries form a file to the internal dictionary.
    - readSMS()
      The readSMS() function reads a SMS message with the phone number of the sender and the time when the message has been sent. Possible errors will be read as well. If you want to use the control function, the runtime script sms.ctl has to run in the console.
    - recode()
      The function converts a string and returns the string in the desired encoding.
    - recodeFileName()
      Obsolete function. Converts a string from system encoding (e.g. ISO8859-1) to WinCC OA encoding (e.g. UTF8), function is intended to be used with file names, but can also be used for other strings.
    - reduActive()
      In a redundant system, returns the active computer.
    - reduSetActive()
      Activates the emergency switch on the left or on the right.
    - reduSetInactive()
      Deactivates the emergency switch on the left or on the right in a redundant system.
    - reduSetPreferred()
      Sets the Preferred to left or right in a redundant system.
    - reduSetSplitOff()
      Sets the split mode to off in a redundant project.
    - reduSetSplitOn()
      Sets the split mode in a redundant system.
    - reduSwitchDist()
      Switches over in the split mode.
    - reduSwitchDriver()
      Switches the drivers in the split mode.
    - regexpIndex()
      The function "regexpIndex()" provides pattern matching via regular expressions. The function searches for a match of the specified character starting from the given position.
    - regexpLastIndex()
      The function "regexpLastIndex()" provides pattern matching via regular expressions. The function searches for a match of the specified character(s) starting at the end of the string.
    - regexpSplit()
      The function "regexpSplit()" provides pattern matching via regular expressions.
    - registerDbgFlag()
      Registers a debug flag and returns a debug flag number.
    - releaseComObject()
      Releases the COM object.
    - remove()
      The function remove() deletes a file.
    - removeDoneCB()
      The function prevents the calculation of unwanted data in data point functions and statistical functions.
    - removeGlobal()
      Deletes the manager-wide global CTRL variable name.
    - removeGroup()
      The function removes a group connection from the panel.
    - removeGroupPVSS()
      Removes a WinCC OA group.
    - removeShape()
      The function removes a shape from the panel.
    - removeSymbol()
      The function is used to delete panel references.
    - removeUserFromGroupPVSS()
      Removes a WinCC OA group from a user.
    - removeUserPVSS()
      The function permanently disables a user.
    - rename()
      The function renames a file.
    - renameGroupPVSS()
      Renames a WinCC OA user group.
    - renameUserPVSS()
      Renames a WinCC OA user.
    - requestFileList()
      The function requestFileList() requests a file list from the manager with the specified manager Id.
    - requestFileTransfer()
      The function requestFileTransfer() requests a list of files to be transferred from the active to passive partner in a redundant project.
    - restorePanel()
      Opens an already loaded child panel that had been minimized.
    - rewind()
      Places the pointer at the beginning of the file FileDesc.
    - rmdir()
      The function deletes a specified directory.
    - rootPanel()
      Returns the name of a particular root panel.
    - RootPanelOn()
      Opens a new panel in the current module.
    - RootPanelOnModule()
      Opens a panel in a particular module.
    - RSAGenerateKeyPair()
      The function RSAGenerateKeyPair() generates a public and a private key for the functions RSASealEnvelope() and RSAOpenEnvelope().
    - RSAOpenEnvelope()
      The function RSAOpenEnvelope() decrypts data.
    - RSASealEnvelope()
      The function RSASealEnvelope() encrypts data.
    - runRealSQL()
      The function runRealSQL executes an SQL command that does not return a value such as INSERT or DELETE.
    - runRealSQLQuery()
      The function runRealSQLQuery executes an SQL query of the RDB database.
  - Functions S
  - Functions T
  - Functions U
  - Functions V
  - Functions W
  - Functions X
  - Functions Y
  - Functions Z
- CTRL Debugger
  With the CTRL Debugger you can debug the programming language Control.

runRealSQLQuery()

The function runRealSQLQuery executes an SQL query of the RDB database.

Synopsis

int runRealSQLQuery(string sqlQuery, dyn_dyn_anytype result);

Parameters


Parameter	Description
sqlQuery	An SQL query. Note that an SQL query must be used. This is not a WinCC OA SQL query. Use the SQL syntax (the commands SELECT, FROM, WHERE etc.). See example further below.
result	The result of the query.

Return value

In the event of an error, the function returns 0 otherwise, 1.

Error

Invalid or missing arguments

Description

The function runRealSQLQuery executes an SQL query of the RDB database. The query is executed by using the current database connection.

Be cautious when using the function. Invalid queries might cause undesired side effects.

Example

The example selects the original values from the table EVENTHISTORY_31615001 and outputs them.

main()
{


   dyn_dyn_anytype result;


   int i;
   i =  runRealSQLQuery("SELECT '_original.._value' FROM EVENTHISTORY_31615001", result);


   DebugN(result);


}

Availability

UI