 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
glory
Guest
|
 Posted: Fri Apr 02, 2004 1:33 am Post subject: I need the detail of BDE connections |
 |
|
what configration is the key to resolve this lock, please give me more help
thanks.
|
|
| Back to top |
|
 |
Bill Todd (TeamB)
Guest
|
| Posted: Fri Apr 02, 2004 1:43 pm Post subject: Re: I need the detail of BDE connections |
|
|
On Fri, 2 Apr 2004 09:33:12 +0800, "glory" <borlandnewgroup (AT) 163 (DOT) com>
wrote:
| Quote: | what configration is the key to resolve this lock, please give me more help
thanks.
|
What lock? You question does not make sense. What database are you
using? What data access components are you using? Provide a detailed
description of the problem.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Predrag Cabarkapa
Guest
|
| Posted: Sat Apr 03, 2004 5:48 pm Post subject: Re: I need the detail of BDE connections |
|
|
Hello,
did you try with "WITH (NOLOCK)"
on my machine I'v got same locking using ADO and BDE.
(type: IS, S)
bye
|
|
| Back to top |
|
|
glory
Guest
|
| Posted: Mon Apr 05, 2004 3:10 am Post subject: Re: I need the detail of BDE connections |
|
|
with Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from t1 ');
ParamByName().AsString:=....;
Open; // at here; there is a share lock when you
memo the next word : Last;
Last; // at this time , unlocked;
// processing.......
Close;
end;
Using MSSQL2000 Server /D5/BDE/Windows2000Server;
when I use ADO connections .there is no lock ;
I know when SQLServer is querying to the table , there is a share
lock or rows or on page but
My question is that : the query is opened and the share lock on
the table should be free, but at now
only I move the pointer to the last of the query . the lock is
free. so that's a big problem to me .
and please test it and reply to me thanks a lot
"Bill Todd (TeamB)" <no (AT) no (DOT) com>
??????:kdrq60tvcnjci25rhn3m82kvs7dlpthg6s (AT) 4ax (DOT) com...
| Quote: | On Fri, 2 Apr 2004 09:33:12 +0800, "glory"
wrote:
what configration is the key to resolve this lock, please give me more
help
thanks.
What lock? You question does not make sense. What database are you
using? What data access components are you using? Provide a detailed
description of the problem.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
|
| Back to top |
|
|
quinn wildman
Guest
|
| Posted: Mon Apr 05, 2004 4:21 pm Post subject: Re: I need the detail of BDE connections |
|
|
The BDE isn't doing any locking here. The server is doing it.
glory wrote:
| Quote: | hello:
just like these code:
with Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from t1 ');
ParamByName().AsString:=....;
Open; // at here; there is a share lock when you
memo the next word : Last;
Last; // at this time , unlocked;
// processing.......
Close;
end;
Using MSSQL2000 Server /D5/BDE/Windows2000Server;
when I use ADO connections .there is no lock ;
I know when SQLServer is querying to the table , there is a share
lock or rows or on page but
My question is that : the query is opened and the share lock on
the table should be free, but at now
only I move the pointer to the last of the query . the lock is
free. so that's a big problem to me .
and please test it and reply to me thanks a lot
"Bill Todd (TeamB)"
??????:kdrq60tvcnjci25rhn3m82kvs7dlpthg6s (AT) 4ax (DOT) com...
On Fri, 2 Apr 2004 09:33:12 +0800, "glory"
wrote:
what configration is the key to resolve this lock, please give me more
help
thanks.
What lock? You question does not make sense. What database are you
using? What data access components are you using? Provide a detailed
description of the problem.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
