>I have 5 views in my database that come from the same data source. What do I need to do if I only want to enter the password once for that data source when I do an SQL-select on these views.
>
>Sam

Use a shared connection. Create a dummy remote view [non-updatable] that selects 1 row from any of the tables. At the beginning of the app, open this view and leave it open for the entire session. If you decide to use SPT in the future, you can use this same connection. Just use CursorGetProp('ConnectHandle', 'View_Name') to get the connection handle to use in SQLExec().

In Oracle there is a dummy table called DUAL that has 1 record. This is what I have my dummy view based on.