1. 

   SBurke, Member

   Hi,

   Currently we have a simple report on one server that takes 4 parameters and updates a table. However we would like to be able to run this report from another myDBR server.

   Looking at this webpage: http://mydbr.com/doc/content/cmd.remotecall.html

   It suggests that we need a local table to receive results. The issue is that there are no results in this report.

   I suppose we can show the resultant changes as an additional query just to have some form of result, but it seems wasteful to have to do this. I.e. adding a query to show a result so we can then create an additional procedure to store it in a temporary table to then show it on the local server, when we do not need to see it.

   Is there a way to achieve this? or do I have to create a result?

   Thanks,
   Simon.
2. 

   myDBR Team, Key Master

   Simon,
   for now the result set from remote server is required, but we can make it optional.

   We'll take a look at it.
   --
   myDBR Team
3. 

   myDBR Team, Key Master

   In the latest build the local table can be null. In that case myDBR does not expect results from remote server, it just executes the remote call.

   --
   myDBR Team

Reply

You must log in to post.