Re: Why Developer 2000 not deleting records from one table ?

Make sure that there is not another connection that is locking the rows you are trying to delete.
Forms will wait until the record is free again.

Joep Hendrix

a_balachandran_at_hotmail.com wrote in article <757dlm$j6r$1_at_nnrp1.dejanews.com>...
> One of my customer having an application which has been
> running for last 1 year with the following settings, stopped
> working.
>
> If someone can give more idea on this background, I will be
> really thankful, as it would help my customer to get into
> the normal situation ASAP.
>
> Server Configuration:
>
> --------------------------------------
> Compaq Prolinea
> 4MM DAT Drive
> CDROM Drive, 64MB RAM, 4GB DAT
> --------------------------------------
> Windows NT 4.0
> Oracel 7.1.3.3
> Developer 2000
> --------------------------------------
> IDE Controller
> Disk 0
> Logical Drive C:\ having WINNT
> Disk 1
> D:\ ORANT
> E:\ Database Files
> --------------------------------------
>
> Tablespace Configurations:
>
> SYSTEM : 50 MB
> ROLLBACK : 350 MB
> USERS : 350 MB
> INDEX : 50 MB
> TEMP : 200 MB
>
> LOG FILES : 3
> CTRL FILES: 2
>
> Problem:
>
> There are about 200 Forms in that Application), which are working
> alright.
>
> Amazingly, only in a particular form, inside a trigger, the code
> is not getting executed.
>
> Fresh startup of NT / Oracle Server, and accessed first time through
> FORMS, the same code works. But not subsequently.
>
> After first time execution of trigger, start SQLPlus either
> from SERVER or CLIENT PCs, and execute the same statement, and give
> commit, then the Dev2000 Forms works till you close the Forms-Runtime
> Application.
>
> In the sense, it is coming into the trigger, but it is not
> executing a line which is looking similar to the following:
>
> ---------------------------------------------------------------------
>
> DECLARE
> { Declare statements }
> BEGIN
> [ Code to process few tables and update PROCESS_DATA table]
>
> -- DEBUG START
> MESSAGE('Check before DELETE ');
> -- DEBUG END
>
> "DELETE * FROM PROCESS_DATA WHERE ARMY_NO = " + army_no
>
> -- DEBUG START
> MESSAGE('Check after DELETE ');
> -- DEBUG END
>
> SET_ITEM_PROPERTY (BTN_CONTINUE, ENABLED, TRUE);
> SET_ITEM_PROPERTY (BTN_CLOSE, ENABLED, TRUE);
>
> END;
>
> ---------------------------------------------------------------------
>
> In the above code, when the form is executed, it shows the first
> message.
>
> But it does not show the second message. And of course, it is not
> deleting any records from PROCESS_DATA also. And it does not
execute
> any code after that.
>
>
> More facts:
>
> - All the tables owned by the same SCOTT/TIGER user only.
> - Tried with only one client, two clients, more than one client
> - Tried with different set of nodes also.
> - The same configuration, same database, same user, same forms
> works fine on a different Backup Domain Controller (NT Server)
> 100% fine.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Thu Dec 17 1998 - 15:38:50 CET