If you are establishing your initial connection by opening a remote view, you can use that views's connection handle to open all other RVs and use SPT. The connection has to be shared. See DBGetProp for info on making connections shared for your RVs. Next --

lnHandle = CursorGetProp('ConnectHandle', 'View_Name')

Now you have a connection handle to use with SPT. Unfortunately, you can not use SQLConnect or SQLStringConnect to get the handle first for use by RVs. You do not need this lnHandle to open other RVs as long as the RVs use a shared connection.

>I am trying to use SQL Server application roles with the connections used on views created in a database container. Is this possible? Since approles are activated upon a connection, how can I make the DBC(and its views) use a connection handle that I already have the approles activated on, prior to retrieving any data? If I could somehow change the DBC connection handle before it retrieves the data, so I could activate the role on the connection, this would solve my problem. I am aware that I could do all of this by totally using SPT to create and manage my connections and connect strings. I would like to minimize the changes that I would have to make, and we are currently using remote views to retrieve our data.