Call Remote Procedures

Question

Is it possible to call a remote stored procedure via a button if the remote server is a linked server?

Comments

Moved from a feature request to a HowTo

Answer 1

dbFront has no knowledge of linked servers or procedures.

I would attempt call the remote procedure from a local procedure.

Comments

Ok, interesting work around. Additional question - is there a way to allow the user to input data that arent part of the table? Example -  I want to create a button that runs a stored procedure that moves data from one server to another server (linked). I would like the user to be able to input the Source and Destination. Im assuming I'd have to add Source/Destination columns to the  table?

---

The ability for custom ActionButtons to prompt users for additional information was added in dbFront 1.0.11.0052.   See: https://dbfront.com/qa/207/allow-a-button-to-prompt-for-additional-information