key group locked error, weird TDBEdit focus error

key group locked error, weird TDBEdit focus error

Post by Kito D. Man » Sat, 08 Jun 1996 04:00:00



I've mentioned these two problems before, but have found no solution:

(1) I'm getting an EDBEngine exception with the message "key group locked" (and then
it gives the username, which is myself, of course). This occurs when chaning the key
and posting a record to a TTable which is the master in a master-detail relationship
with many other tables. If anyone knows anything about this exception, I'd greatly
appreciate any insight. The problem only seems to occur when the table which to
which the record is being posted has detail tables, and it only occurs when I'm
modifying the key (there is only one key field).

(2) When moving from a TEdit field, loading another form (via ShowModal), and then
returning, I'm expecting the focus to go to the next field in the TabOrder, which is
a TDBEdit. Although the TDBEdit does have focus and is the active control, for some
reason I can't edit the field (it won't let me click within the box). If I click on
another field, type something in, and then move back, everything works fine. This
only occurs when the second form is popped up after the first field. Any ideas?

~~~~~~~~~~~~~~~~~~ "the revolution is now. why settle?" ~~~~~~~~~~~~~~~~~~~~~~~~~~
Kito D. Mann                                            Virtua Communications Corp

(410)662-7280                                           3100 Falls Cliff Rd. #200
(410)467-0127 (FAX)                                     Baltimore, MD 21211

 
 
 

key group locked error, weird TDBEdit focus error

Post by Jasper St » Tue, 11 Jun 1996 04:00:00



Quote:> I've mentioned these two problems before, but have found no solution:

> (1) I'm getting an EDBEngine exception with the message "key group locked" (and then
> it gives the username, which is myself, of course). This occurs when chaning the key
> and posting a record to a TTable which is the master in a master-detail relationship
> with many other tables. If anyone knows anything about this exception, I'd greatly
> appreciate any insight. The problem only seems to occur when the table which to
> which the record is being posted has detail tables, and it only occurs when I'm
> modifying the key (there is only one key field).

Classic! By modifying the key of your master record, the details loose
their connection and you're violating some referential integrity. If
this is really what you want, you should change the reference in the
details (or set them to null, if your DBMS accepts that) prior to
posting the master.

Quote:> (2) When moving from a TEdit field, loading another form (via ShowModal), and then
> returning, I'm expecting the focus to go to the next field in the TabOrder, which is
> a TDBEdit. Although the TDBEdit does have focus and is the active control, for some
> reason I can't edit the field (it won't let me click within the box). If I click on
> another field, type something in, and then move back, everything works fine. This
> only occurs when the second form is popped up after the first field. Any ideas?

Just a wild guess: the readonly property of your TTable, TDBEdit or
the corresponding TField has been set to true by your modal form?

Jasper

PS: please take into consideration
- when replying, I just think I know;
- when asking, be sure that I don't.

 
 
 

1. HELP -- "Key group is locked" error

Greetiings, here is the situation...

I have a small database (2 fields... but both are keyed and linked to
other dependants)... in my app I can change either field (and post it) in
the DB once.  On a second attempt to post I get the "Key group is locked"
error.  I am using D1 on a WIN95 platform.  Also I am accessing the DB
through a TQuery component.

Thanks in advance, NM.

2. Why the 3043 err when using UNC vs. mapped network drive ????

3. Key group is locked error?

4. VB 5.0 Database Programming Book

5. Key group is locked error

6. Help using SQL index Names

7. in-memory tables, key-group locked error, copying records

8. Table hits

9. Lock time error... weird

10. HELP on: ISAM error: key value locked

11. Lock For Primary Key error

12. Key lock error

13. TDBEdit - trapping input errors