Why is this different in VFP8 from VFP7 and VFP6. In VFP7 I get the
same connection handle from the View as I do with the spid.
CLEAR
CLOSE DATABASES all
SET ENGINEBEHAVIOR 70 && doesn't change the behavior
OPEN DATABASE myDatabase
USE myView1 NODATA
USE myView2 NODATA IN 0
USE myView3 NODATA IN 0
?"Connection Handle for MyView1 RV:
"+ALLTRIM(STR(CURSORGETPROP('connecthandle','myView1')))
?"Connection Handle for MyView2 RV:
"+ALLTRIM(STR(CURSORGETPROP('connecthandle','myView2')))
?"Connection Handle for MYVIEW3 RV:
"+ALLTRIM(STR(CURSORGETPROP('connecthandle','myView3')))
?"Shared Connection Property on MyView1 RV:
"+IIF(DBGETPROP('myView1','view','shareconnection'),'Yes','No')
?"Shared Connection Property on MyView2 RV:
"+IIF(DBGETPROP('myView2','view','shareconnection'),'Yes','No')
?"Shared Connection Property on MYVIEW3 RV:
"+IIF(DBGETPROP('myView3','view','shareconnection'),'Yes','No')
LOCAL m.spid
=SQLEXEC(CURSORGETPROP('connecthandle','myView1'), 'Select @@spid as
spidval', 'tspid')
m.spid = tspid.spidval
?"MyView1 SPID: "+ALLTRIM(STR(m.spid))
=SQLEXEC(CURSORGETPROP('connecthandle','myView2'), 'Select @@spid as
spidval', 'tspid')
m.spid = tspid.spidval
?"MyView2 SPID: "+ALLTRIM(STR(m.spid))
=SQLEXEC(CURSORGETPROP('connecthandle','myView3'), 'Select @@spid as
spidval', 'tspid')
m.spid = tspid.spidval
?"MYVIEW3 SPID: "+ALLTRIM(STR(m.spid))
CLOSE DATABASES all
Barry Childs
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
©2003 Barry Childs |
