Dynamics SL Custom Table Permissions for PV Lookups

posted on October 25, 2016 by | 1 Comment

I created a PV Lookup (showing Possible Values) for a custom table for a Microsoft Dynamics SL 2015, CU 1, SDK application. Immediately after pressing F3 I got a TargetInvocationException in Visual Studio. The Visual Studio Output window listed an unhandled exception in the Microsoft.Dynamics.SL.Controls assembly at SetSqlDataSource. Digging into the Call Stack showed the exception came from the CTLBPVSql method in the swimapi.dll. A SQL Trace showed a statement that ran correctly using my credentials, but Dynamics SL runs it as the... Continue reading →