Hello Andrus,

I do it the other way round. I start by creating a connection and a first remote view.
Then I get the connection handle used by this view.
I use this connection handle in all subsequent SPT's

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.