Symptoms
SmartObject List Method Not Working.
Diagnoses
I am using a SmartObject to write data to a SQL table. Create, Update, and Read work fine and the table is being filled with data. However, when I try to execute the List method, no data is being returned.
Resolution
The Service Instance of the SQL connection was set incorrectly. In the SmartObject Tester Tool and drill down from the top into ServiceObject Explorer > SQL Server Service > Right Click on your service and select edit. Check the flag that says Use Native SQL Execution - Required. If your SQL server is on another server (not local) then set that to false. By default it's set to true, of which not too many systems have a local SQL server install.
