The action retrieves the SQL query from the database, executes it and assigns the results to variables whose identifiers correspond to the column aliases in the database. Places in the database query, where the values from parameters defined by us are to be marked, are marked with "?" If several parameters are defined, the order in which the parameters are defined determines where each value will go. It should be remembered that writing data to the dynamic table is possible only after passing the table identifier in the last parameter. In the absence of data returned from the database, the component sets no value. |