Board index » delphi » Table block

C.Fleury

Delphi Developer
Wed, 07 Dec 2005 02:55:45 GMT

Table block

Hi,
I not even know how to start explaining my problem. Basically when two
computers are in the same option which displays/modifies a particular table,
the station attempting to post a entry will be locked until the station
which is displaying a list from the same table (not necessarily the same
record) closes the list.... The problem is totally consistent and I have no
clue how to resolve it.

(D5 and 7 / MS-SQL7 and MS-SQL2000 / BDE)

Any ideas ?

Thanks
C.Fleury

 
Eric Hil

Delphi Developer
Wed, 07 Dec 2005 12:16:28 GMT

Re:Table block


Sounds like a locking problem.  Are you using optomistic or pessemistic
locking?

Eric

C.Fleur

Delphi Developer
Wed, 07 Dec 2005 23:02:24 GMT

Re:Table block


Hi Eric,
I'm using the BDE and TQuery which doesn't offer those properties (I think
!). I made sure to delete and re-create all data sets and data sources
involved in the process to make sure all Borland defaults are kept in place,
but the same behavior persists.
Thanks
C.Fleury

Quote
"Eric Hill" <e...@ijack.net> wrote in message

news:3ef3dc1c$1@newsgroups.borland.com...
Quote
> Sounds like a locking problem.  Are you using optomistic or pessemistic
> locking?

> Eric

Kevin Frever

Delphi Developer
Fri, 09 Dec 2005 21:01:24 GMT

Re:Table block


How is the data modified?  RequestLive? CachedUpdates?  Are you explicitly
starting/committing transactions in Delphi code (Database1.Commit on a
button click)?

krf

Quote
"C.Fleury" <Fle...@CompuTimes.net> wrote in message

news:3ef473b2$1@newsgroups.borland.com...
Quote
> Hi Eric,
> I'm using the BDE and TQuery which doesn't offer those properties (I think
> !). I made sure to delete and re-create all data sets and data sources
> involved in the process to make sure all Borland defaults are kept in
place,
> but the same behavior persists.
> Thanks
> C.Fleury

> "Eric Hill" <e...@ijack.net> wrote in message
> news:3ef3dc1c$1@newsgroups.borland.com...
> > Sounds like a locking problem.  Are you using optomistic or pessemistic
> > locking?

> > Eric

C.Fleur

Delphi Developer
Fri, 09 Dec 2005 21:35:47 GMT

Re:Table block


Kevin,
There are two forms, form1 has a TBrowse w/ a TQuery (RequestLive=False) and
form2 when activated uses another TQuery (RequestLive=True) which selects
the one highlighted record in then form1's Browse and edits it.
 When I post the edit in form2 it will sit there waiting until the remote
station which is idle in form1 closes it either by activating form2 or going
back to a menu. This is equivalent in complexity to the HELLO WORLD of
Delphi programming and I can't get it to behave properly !!!

Thanks

C.Fleury

Quote
"Kevin Frevert" <ke...@workdrinkingcoffee.com> wrote in message

news:3ef6fa24$1@newsgroups.borland.com...
Quote
> How is the data modified?  RequestLive? CachedUpdates?  Are you explicitly
> starting/committing transactions in Delphi code (Database1.Commit on a
> button click)?

> krf

> "C.Fleury" <Fle...@CompuTimes.net> wrote in message
> news:3ef473b2$1@newsgroups.borland.com...
> > Hi Eric,
> > I'm using the BDE and TQuery which doesn't offer those properties (I
think
> > !). I made sure to delete and re-create all data sets and data sources
> > involved in the process to make sure all Borland defaults are kept in
> place,
> > but the same behavior persists.
> > Thanks
> > C.Fleury

> > "Eric Hill" <e...@ijack.net> wrote in message
> > news:3ef3dc1c$1@newsgroups.borland.com...
> > > Sounds like a locking problem.  Are you using optomistic or
pessemistic
> > > locking?

> > > Eric

Kevin Frever

Delphi Developer
Fri, 09 Dec 2005 23:08:19 GMT

Re:Table block


C.Fleury,

Welcome to client/server development.  The server is only doing what you ask
and the tricky part is making sure you ask the right questions, in the right
way.  There is a lot of detail you keep leaving out (number of records
involved, what server resources are locked, SQL used, etc), so here are a
few articles worth reading...

http://bdn.borland.com/article/0,1410,28160,00.html
http://community.borland.com/article/0,1410,22571,00.html
http://community.borland.com/article/0,1410,20563,00.html

Good luck,
krf
http://www.midwayusa.com
- 100% Delphi Webbroker CGI/ISAPI and ADO against MSSQL 2K

Quote
"C.Fleury" <Fle...@CompuTimes.net> wrote in message

news:3ef70232$1@newsgroups.borland.com...
Quote
> Kevin,
> There are two forms, form1 has a TBrowse w/ a TQuery (RequestLive=False)
and
> form2 when activated uses another TQuery (RequestLive=True) which selects
> the one highlighted record in then form1's Browse and edits it.
>  When I post the edit in form2 it will sit there waiting until the remote
> station which is idle in form1 closes it either by activating form2 or
going
> back to a menu. This is equivalent in complexity to the HELLO WORLD of
> Delphi programming and I can't get it to behave properly !!!

> Thanks

> C.Fleury

Other Threads

1. Paradox table block size

2. Table Blocked

3. Increasing Paradox Table Block Size

4. Table blocked

5. SQL Explorer 4.00 table blocking SQL Svr 6.5

6. Table Block Size Question

7. Paradox Table Block Size

8. Paradox tables block size

9. Paradox Table block size.

10. Table BLOCK SIZE ?