[odb-users] Query Stored Procedure (SQL Server)

[Tarik BENZ]

Hello,

I am trying to use the native view to call a stored function

#pragma db view query("EXEC GetEligibleParticipant (?)")
struct Preparation_View
{
    std::string participantCode;
    odb::nullable<std::string> lastName;
    odb::nullable<std::string> firstName;
}

But I have this error during the compilation

Preparation_View.hxx:13:8: error: view '::Preparation_View' has an incomplete query template and no associated objects
Preparation_View.hxx:13:8: info: use db pragma query to provide a complete query template
Preparation_View.hxx:13:8: info: or use db pragma object to associate one or more objects with the view

Kind Regards