>Well, I set all the remote views to share connection, and now my screen will not run, "connection busy" 1541 error. Any other suggestions?


The default on remote views is to retrieve 100 records in a batch (unless you set to query to retrieve all records). What happens is your select is retrieving more than 100 records but processing has moved on to the next cursor request on the connection before the previous one has finished. Make sure your remote views are set to retrieve all records.

This implies that your result sets are larger than necessary. So, you can share the connection, but each request must completely process (syncronously) before the connection can be used again.

In your opentables, a remote view is trying to open before the connection is free (because the previous view is returning more than 100 records). This is handy when populating a grid and you don't want to wait for all the records to be retrieved while browsing. Not so good when loading multiple tables.