>Mark,
>
>Thanks for the response,
>
>Do you use remote views or sql pass-through? how do you handle a busy connection or do you just hope for the best?
>
>...tim
I use a combination of both views and SPT. Once I establish the connection with a remote view, I use CursorGetProp("ConnectHandle", View_Name) to get the connection handle. I use this handle in my SPT. I use views for all updatable data and some read-only. I use SPT for really complex SQL like those with UNIONs.
I use the synchronous option so I have an error trap on error #1541 and give the user a choice to retry or cancel the query. The only time I got this error was when I change the number of records to retrieve for my dummy view to 1 instead of all. This surprised the heck out of me becasue the table only had 1 record.
Mark McCasland
Midlothian, TX USA