MSSQL and XBROWSE

[Jack]

Hi,
With standard DBF open in SHARED mode, when a table is open and displayed with XBROWSE on 2 computer in the network, if 1 user update a record , the change is visible on the xbrowse on the other computer . (There is an automatic refresh)

How is it possible with RecordSet ?
I think i have to change the CursorType .


oRsa:= CREATEOBJECT( "ADODB.Recordset" )
oRsa:LockType := 3 // lockoportunistic
oRsa:CursorType := 1 // opendkeyset
oRsa:CursorLocation := 3 // local cache
*

Thanks,

Philippe

[Rick Lipkin]

Jack

You are going to have come up with a timer that does some sort of oLbx:ReFresh() and or oRs:Requery() at some selected interval .. Hopefully someone will chime in here with a timer code example ..

Rick Lipkin