Josh,
A definate step in the right direction. Situation is this: I have asynchronous checked in the connection, I'm only using 1 remote view in my test form. If I have the FrechSize set to anything less than the total number of records then I get the 'Connection Busy' error. If I have change the ShareConnection setting in the view, same problem. (Which I guess makes sense because their is only one remote view for the form).
->My problem is that I don't want to have to fetch ALL the records, I just want to fetch one at a time. Is this possible? And even if it is, is it a dumb idea to do so? My assumption is that if user#1 changes a record, then user#2 will see the change right away (when they go to the 'changed' record) if the 'fetching' gizmo is set to 1, right?
Victor,
Usually, a connection busy error occurs when you have two commands executing over the same connection at once. This can happen when views share a connection and the connection is set for asynchronous execution, or if one or more of the views sharing a connection have the FetchSize (# of records to fetch at a time) set to something other than -1 (all).
>I'm using Oracle 8 tables, the MS ODBC Driver for Oracle, and Remote Views. When I try to do a =TableUpDate(.T., .T.) I keep getting a 'connection xxxxx busy' error. I don't think I've had this problem until recently. I've tried changing the 'share connection' option in the remote view, but still same problem. My guess (GUESS being the operative word here - I'm new to Oracle & Remote Views & ODBC) is that I've screwed up the view somehow. Anyone have any ideas on where I should look? Thanks.
ICQ 10556 (ya), 254117