>Hi all
>
>I'm trying to use both a Remote view and Sql Pass Through to make a maintenance form for my SQL Server Database tables.
>
>I just want someone to give some advice in how to make the whole thing with a simple example, when I use SQLEXEC(Myconnection, "MySql sentence") I have made Myconnection using a remote view, but to use that connection handler I need to save it to a memory variable and I don't know exactly how. If a use SPT only, I have no problem, but, I wanna be able to use both because of the graphical interface that I have access to if I use a Remote View, it saves me the pain of writing all those lines if I use SPT only.


To get the connection handle of the remote view use:

myhandle=CURSORGETPROP("ConnectHandle","YourRemoteView")

This will return the connection handle of the remote view you are using. Then you can use that connection for your SQLEXEC commands.