Purpose: Executes a command query, for example "DROP TABLE MY_TABLE" aganist a database and returns rows affected


Properties


  • Name: Connection
    • Type: Select from list
    • Direction: in
    • Purpose: Database connection in which query is performed 


  • Name: Query
    • Type: String
    • Direction: in
    • Purpose: Sql ANSI to execute


  • Name: Result
    • Type: Integer
    • Direction: out
    • Purpose: rows affected


Remark: if You have Oracle database as back-end store and You want to execute a stored procedure set Query property to something like "begin my_procedure(); end;"