Michael Earls

02/24/2022, 3:48 PM
Good day. I have successfully connected to SQL server as I am able to get data from a Stored Procedure. I have setup my DAO objects and companion classes. However, my tables are in a schema and I am unable to select their columns. I have tried adding the full "DATABASE.SCHEMA.TABLENAME" to the name= parameter of the constructor, but that didn't work. It tries to access the columns in the SELECT using no schema information. How to I configure exposed to use the table's schema when selecting columns? Thank you for any help you can provide.