FORMS 3.0: Canceling reserving record for update.

From: (wrong string) ®eljko Juriæ <zjuric_at_hotmail.com>
Date: Fri, 24 Mar 2000 23:02:18 +0100
Message-ID: <8bfv84$ej9$1_at_as102.tel.hr>

Oracle application: POS system, 6 years from first installation, Based on FORMS 3.0, ORACLE 7.3.X

Operating system: Novell server, DOS workstations with Novell clients

Recent changes: Before few months Novell server changed with Windows NT, workstations still on DOS but with MS client. Protocol changed from IPX/SPX to TCP. Because of Y2K bug, database filled with triggers like:

---

TRIGGER Y2K_ZAH_DOMENE
    BEFORE INSERT OR UPDATE
    ON ZAH_DOMENE
    FOR EACH ROW
BEGIN     IF :new.DAT_AZUR IS NOT NULL THEN

       :new.DAT_AZUR:= TO_DATE(TO_CHAR(:new.DAT_AZUR,'DDMMYY'),'DDMMRR');     END IF;  END;

---

PROBLEM ! When few (5-10) clients works on the same table Forms 3.0 show the message (something like):

Reserving record for update, <Ctrl><C> for cancel.

BUT, <CTRL><C> doesn't work, and a user must wait for somebody to press COMMIT. Of course, time is money, and my clients looses nerve, so he/she presses <Ctrl><alt><delete> and everything becomes messy...

Thanks in advance

    Jure

 Rijeka, Croatia, Europe Received on Fri Mar 24 2000 - 23:02:18 CET