Create CONNECTION ccon ; CONNSTRING "dsn=...." Create SQL VIEW Myview ; REMOTE CONNECTION "ccon" SHARE ; AS select * from mytable con_dbhandle=cursorgetprop("ConnectHandle","Myview") sqlexec(con_dbhandle,"select mycolumn from myothertable","mycursor")So, from now on, every «Create SQL VIEW» and every «sqlexec», will use the same connection to the server.