Prev: SQL record locking
Next: Vo2Ado Sql Server Adding Constraint
From: Stephen Quinn on 2 Sep 2008 18:59
Eckhard

> as i see on the monitor.nlm on the novel server, the index is not openened
> twice, it will only be reopened.

The DBFCDX RDD on the client has a pointer to the copy it opened
automatically, re-opening the file on the Server doesn't update that pointer
in the client.
ie
the client points to it's copy of the index and the server points to
it's new copy
when the client tries to write you see an error
the 1011 error your seeing points to an index problem

The DBFCDX RDD doesn't close structural index files until the DBF is closed.

> in think the problem is the rlock() wich will not work, using flock()
> instead will work fine
Which version of the Netware client are you using
- there have been versions that Clipper has problems with.

CYA
Steve


From: Eckhard Sallermann on 3 Sep 2008 06:20
Hi Stephen,

this it is located in the helpfile:

Example

use demo && Brings all tags in demo.cmx into use
set index to first && Bring first into use
set index to last && Close first, bring last into use
set index to first additive && Now bring first into use,
&& keeping last open

so when using "set index to xyxc" the currently opended index will be closed
before, am i missunderstanding anything ?

"Stephen Quinn" <stevejqNO(a)SPbigpond.AMnet.au> schrieb im Newsbeitrag
news:gzjvk.33237$IK1.5011(a)news-server.bigpond.net.au...
> Eckhard
>
>> as i see on the monitor.nlm on the novel server, the index is not
>> openened twice, it will only be reopened.
>
> The DBFCDX RDD on the client has a pointer to the copy it opened
> automatically, re-opening the file on the Server doesn't update that
> pointer in the client.
> ie
> the client points to it's copy of the index and the server points to
> it's new copy
> when the client tries to write you see an error
> the 1011 error your seeing points to an index problem
>
> The DBFCDX RDD doesn't close structural index files until the DBF is
> closed.
>
>> in think the problem is the rlock() wich will not work, using flock()
>> instead will work fine
> Which version of the Netware client are you using
> - there have been versions that Clipper has problems with.
>
> CYA
> Steve
>


First  |  Prev  | 
Pages: 1 2 3
Prev: SQL record locking
Next: Vo2Ado Sql Server Adding Constraint