Confiforms building SQL with JOIN

Question

Hello,

I have a quick question regarding building Confiforms dropdown fields using an SQL statement.

My SQL is joining two tables and it's correctly working in MS SQL, but when I add the same code to the database dropdown field, I'm getting an error. Can you tell me whether such connections are allowed in Confiforms?

Thank you in advance.

Error: Reason: The SELECT permission was denied on the object 'EmployeeRate', database 'CAPTOOL', schema 'dbo'.

EmployeeRate - it's the second table in my SQL join

Alex Medved _ConfiForms_ · Accepted Answer

Hi @Andrzej

I believe this is something you should check with your database administrator to see if the user used to connect ConfiForms to the database has enough permissions to access the mentioned tables and the schema

Alex