Re: developer 2000 call form passing variable

Hi Sharma,

It seems that you are trying to assign a value to the project.projno item in the QUERY_ONLY mode... It's not permitted...

Try to use

    IF (:global.directory = 'y') THEN

                         ENTER_QUERY;
                         :project.projno := :global.projno;
                         EXECUTE_QUERY;

instead of

    IF (:global.directory = 'y') THEN

                         :project.projno := :global.projno;
                         EXECUTE_QUERY;

Everything is okay with 'passing' the global variable :global.projno... :-)

Hope that helps.

ssharma24_at_my-deja.com wrote:
>
> I am having a problem passing a global variable in call forms:
>
> Form A is calling Form B:
> When button Pressed trigger in Form A:
> :global.directory := 'y';
> :global.projno := :Blockname.projno;
>
> CALL_FORM ('form b', no_hide, no_replace, query_only);
>
> When new form instance in form B:
> BEGIN
>
> IF (:global.directory = 'y') THEN
> :project.projno := :global.projno;
> EXECUTE_QUERY;
> else
> SET_WINDOW_PROPERTY ('PROJ_FILE_WINDOW', WINDOW_STATE, MAXIMIZE);
> DEFAULT_VALUE (NULL, 'GLOBAL.FILETYPE');
>
> END IF;
> :global.directory := null;
> :global.projno := null;
>
> EXCEPTION
>
> WHEN others THEN
>
> MESSAGE (sqlerrm);
> MESSAGE (' ', NO_ACKNOWLEDGE);
> RAISE form_trigger_failure;
>
> END;
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru