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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.