Me and my team are developing a dart back-end and we need to call stored procedures and retrieve result recordsets with column names.
It is possible with this driver?
Many thanks.
EDIT:
It works.
final List<Map<String, dynamic>> results = await conn.mappedResultsQuery("SELECT * from get_user_by_id(@id)", substitutionValues: {"id": id});
Recordset is retrieved correctly, but appears as a child of table "null".
Me and my team are developing a dart back-end and we need to call stored procedures and retrieve result recordsets with column names. It is possible with this driver?
Many thanks.
EDIT: It works.
final List<Map<String, dynamic>> results = await conn.mappedResultsQuery("SELECT * from get_user_by_id(@id)", substitutionValues: {"id": id});Recordset is retrieved correctly, but appears as a child of table "null".