Smartsite Documentatie > SXML > Macro Parameters > Mode (SqlQuery) Macro Parameter
The mode determines if a datatable, a scalar or the number of affected records is returned.
Enum values:
  • DataTable
    A datatable is returned.
  • Scalar
    A scalar is returned.
  • NonQuery
    The affected record count is returned.
  • StoredProcedure
    Executes a stored procedure.

Properties

Data type Attribute
Enum -

Used in

Macro Description
SqlQuery Executes sql queries/statements and shows the results.
SXML