Setting global variables in FORMS 5

From: David Williams <david.williams_at_daytonoh.ncr.com>
Date: 1998/04/10
Message-ID: <01bd64a7$5c32efc0$be531995_at_aohemd6willid1.DaytonOH.NCR.COM>#1/1

All,

[Quoted]         I've got something really weird happening. If anyone knows how to fix this [Quoted] [Quoted] I would be really grateful. I have the following trigger set up: KEY-NEXT-ITEM with the following code :-

begin

  select user_name, password, user_id
  into   :ENV_USERS.username,


         :ENV_USERS.user_password,


         :ENV_USERS.user_id


  from   env_users
  where  user_name = :ENV_USERS.username

  and password = :ENV_USERS.user_password   and active = 'Y';

  :GLOBAL.user_id := TO_CHAR(:ENV_USERS.user_id);   

  NEW_FORM('C:\ORAWIN95\FORMS50\Localisations\Quickcodes');

exception
  when no_data_found then
    message ('Username/Password not valid');     go_item('ENV_USERS.username');
    raise form_trigger_failure;

end;

Everytime this trigger fires I get the following error when it tries to open the new form :-

F50DBG32 caused a stack fault in module F50COM32.DLL at 0157:5d41fad8. Registers:

EAX=00b1ca10 CS=0157 EIP=5d41fad8 EFLGS=00010246
EBX=00000001 SS=015f ESP=00aef558 EBP=00000000
ECX=00b14968 DS=015f ESI=00000001 FS=120f
EDX=00aef5a0 ES=015f EDI=00000000 GS=0000

Bytes at CS:EIP:
f6 45 08 10 74 11 8b 78 18 8b 44 24 30 89 38 bf Stack dump:
00b1981c 00b695f8 00b4b95c 00b0af60 00000000 00b14414 00000008 5df0e735 00b0af60 00b55750 00aef5a8 00aef5ac 00aef5b0 00aef5a0 00000004 00b1981c

HELP !!!!!!! Received on Fri Apr 10 1998 - 00:00:00 CEST