Purpose: Executes a select query aganist a database and return a dataset


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: String
    • Direction: out
    • Purpose: record count


  • Name: ResultTable
    • Type: DataTable
    • Direction: out
    • Purpose: table returned from query