Hi Nick,

Assuming you are talking about ODBC connections, if you are using SQLEXEC, just initialize each connection individually;

nSqlConnect1 = SQLCONNECT('DBCONN1')
nSqlConnect2 = SQLCONNECT('DBCONN2')
...
SQLEXEC(nSqlConnect1, "SELECT * FROM MYTABLE1")
SQLEXEC(nSqlConnect2, "SELECT * FROM MYTABLE2")

Remote views already have it defined internally whet connection to use.

HTH,
Arriyel

>if I have multiple connections defined in project manager, how can I use a specific connection programatically?
>
>thanks
>nick