Using SqlServer Views locally

Using SqlServer Views locally

  

I have been trying to load a SQLServer view into local storage.  I have an offline server action that gets the data from the view. But it won't let me insert the records into the local view.  When I try to setup an output variable it should be the local table list.  It is not allowing me to insert this and the option to select it is not available in the pull down list.

I am sure there is a simple answer but it is frustrating the crap out of me

Thanks

Andy


Hi Andrew, with mobile development you need to take a close look into the server and client actions. The Local storage and its entities can only be accessed from client actions. You are running a sql query on a view, which means you are working with a server action.

To fix this issue for you, create a structure (not local storage) that you use as output on your query. Use this output as input on a client action and add this input to the local storage. 

For more details you can check the synchronization best practices. 

Kind regards,

Remco Dekkinga