[SOLVED] Schema in SQLSRV not working

I have the following configuration using SQLSRV in database

PHP Code:

'DBPrefix' => '',
'schema' => 'adm',
'pConnect' => false, 


I necessarily have to use adm schema instead of dbo, however I see that the selection statement is not taking the schema that I am assigning to it in the configuration file.

PHP Code:

class UserController extends BaseController
{
    public function index()
    {
        $userModel = new UserModel();
        $entity = $userModel->find(2);
        dd($userModel->db->getLastQuery());

    }
} 


result :

PHP Code:

SELECT *
FROM "users"
WHERE "users"."id" = 2 


PHP Code:

SELECT *
FROM "users"
WHERE "users"."id" = :users.id: 


   

   

PHP Code:

class UserModel extends Model
{
    protected $DBGroup              = 'default';
    protected $table                = 'users';
    protected $primaryKey           = 'id';
    protected $useAutoIncrement     = true;
    protected $insertID             = 0; 


On the other hand, if I rename the table to "adm.user" the selection is done correctly, but the insert or update statement then if I use the getFullName it returns DB.schema.tableName => "DB". "Schema" . "schema.tablename".







   

Hernan Rodríguez
[email protected]