Devart Forums

Hello!
Is it possible to pass stored procedure parameters by name instead of by index (default behaviour) for TMSStoredProc? As i see, i can pass parameters by name only in TMSQuery, but it does not support automatic generation of SQL with named pairs of parameters, something like exec Test @Param = :Param (it is our best practice to avoid parameter's confusion)
Best regards, Konstantin

In the SQL query generated by TMSStoredProc, parameters for calling the stored procedure will be sent ordered by index. If you need to pass parameters in another order, you can generate such SQL query by yourself and and assign it as a value for the TMSStoredProc.SQL.Text property.