VFP8 Remote view gotcha 
Author Message
 VFP8 Remote view gotcha

In VFP7 creating remote views using a shared connection returned the same
connection handle for each open view and 1 process on MSSQL Server. Now in
VFP8 these shared views are all different connection handles. This creates a
problem with record locking since SQL server considers these separate users
(SPID's). If you query 2 views with the same source table in a SQL
transaction one will block the other. My guess is this was a change to VFP
for the cursor adapter.
VFP7:
?CURSORGETPROP("ConnectHandle","myview1") &&returns 1
?CURSORGETPROP("ConnectHandle","myview2") &&returns 1
VFP8:
?CURSORGETPROP("ConnectHandle","myview1") &&returns 1
?CURSORGETPROP("ConnectHandle","myview2") &&returns 2
It seems this change will break some code.


Mon, 10 Oct 2005 21:47:36 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. VFP8 remote views connection handle problem

2. Remote views in VFP8

3. Remote views in VFP8 (maximum open cursors exceeded)

4. Creating a View using a remote view to Oracle

5. view designer says error when using mssql functions in remote views

6. Which is Better: Local Views or Remote Views

7. Remote View prompting for parameters on CREATE SQL VIEW

8. Remote view prompting for parameters on CREATE SQL VIEW

9. view cide for remote view

10. Remote View vs. Local View

11. View V. Remote View - Reposted Q

12. VFP Local view to Remote view generator.

 

 
Powered by phpBB® Forum Software