Re: [Developer 2000] Several problems with Form Builder

Hi Sydney,
1) This error code appears when you do a commit on a table for which no block exists, and there have been no changes made to any of the basetable block(s). By Forms logic, you have not made any changes to the form. You can trap this error and ignore it as long as your code is doing what you want it to do.

2) I'm assuming the button does something else in addition to trying to turn itself off, such as move you to a new canvas, block or item. The code to change the ENABLED property of the button should be moved to a PRE-TEXT-ITEM trigger on the item where the button is taking you, then it will work.

3) Make sure both canvasses are in the same window, if not SHOW_VIEW will open the window containing AIDE, but stack it behind the window containing CANVAS32.

Hope this helps.
Paul

In article <814iua$8ui$1_at_wanadoo.fr>,   "Sydney" <sydney_at_i-france.com> wrote:
> Hi
>
> I have some problem with Form Builder.
>
> 1) Here is a PL/SQL to insert a student in the table etudiants.
> Button : Insert Event: WHEN-BUTTON-PRESSED
>
> declare
> nb number(3);
> begin
> select count(*) into nb FROM etudiants WHERE etudiantID =
> :etudiants.etudiantID;
> if nb = 0 then
> insert into etudiants values
> (:etudiants.etudiantID,:etudiants.nom,:etudiants.salarie,
> :etudiants.departement,:etudiants.sexe,
> :etudiants.semestre,:etudiants.annee);
> commit;
> message('Etudiant ajoute');
> else
> message('Etudiant deja existant');
> end if;
> end;
>
> The problem is coming from the commit. The error FRM-40401 appears.
The help
> tells nothing to solve this problem.
> The commit is indispensable, if I remove the commit, the data are not
> validated.
> Have you an idea?
>
> 2) Problem with SET-ITEM-PROPERTY
> Button : Modifier Event: WHEN-BUTTON-PRESSED
>
> SET_ITEM_PROPERTY('MODIFIER',ENABLED,PROPERTY_FALSE);
>
> I have an error FRM-41032 which tells me that I can't modify the
property
> ENABLED of button Modifier because this button is ACTIVE.
> At the beginning, the button MODIFIER is ENABLED, if I pressed it, it
want
> it to become DISABLED.
> How to do this?
>
> 3) Content Canvas - Stack canvas
>
> I have a content canvas called CANVAS32 and a stack canvas called
AIDE. On
> the CANVAS32, I have a button HELP with this PL/SQL code.
> begin
> SHOW_VIEW('AIDE');
> end;
> The problem, is that canvas AIDE is not showed at the screen.
> Why?
>
> Thanks a lot for your answer
> Sydney from FRANCE
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 20 1999 - 16:31:46 CET