I have used UniDac VCL components for Delphi for a year now but recently started quite a big project with SQL Server 2012 and I want to separate the tables and stored procedures in different schemes my whole logic is in stored procedures so no query's in the program only the stored procedure names and parameters.
The problem is that when I change my stored procedure schema from dbo
to let's say SchemaA
and then try to run it from Delphi the TUniStoredProc
component finds it as ProcedureName
and not as SchemaA.ProcedureName
which throws the exception of not finding the stored procedure on execute.
I can't assign different schemas to different users as their default schemes because there are users that use from 4-6 schemes depending on the permissions. What I tried already is manually entering SchemaA.ProcedureName
and that works perfectly but doing so for ~150 components would take a lot of time so I'm searching for a better solution.
Any thoughts?