On Sun, 9 May 2021 21:16:04 -0500 Ravi chandra <particlere...@gmail.com> wrote:
Rc> Hi SOCI developers,
Rc>
Rc> [A] I had to change this string to get the Table names from MS SQL SERVER
Rc> default schema "dbo".
Rc>
Rc> virtual std::string get_table_names_query() const
Rc> {
Rc> return "select table_name as \"Yummy_Data\""
Rc> " from information_schema.tables"
Rc> " where table_schema = '*dbo*'";
Rc> }
Rc>
Rc> This returns all the Table names.
This can't be done here (in session_backend) as it affects all backends,
but should be overridden in the ODBC backend code when using SQL Server
(there is already a function to do it, I think). If you can do it like
this, please create a PR implementing this and I'd be glad to merge it,
especially if it includes at least a simple unit test for the new
functionality.
Thanks in advance,
VZ
pgpM0L9gbXWIm.pgp
Description: PGP signature
_______________________________________________ soci-users mailing list soci-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-users
