>>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.
>
>Remote views are async by default, you change them to sync with sqlsetprop(), you use a shared connection so do just set this once on your dummy table?
>
>...tim
In my VFP Options, I unchecked the Asynchronous Option. So all views I create are defaulted to Synchronous. Yes, you only have to set the property once. Since you are setting the properties of the connection, all views using that connection will be affected by what you set for that connection. This is true for any connection property that can be changed with SQLSetProp.
Mark McCasland
Midlothian, TX USA