1 2 3 Previous Next 42 Replies Latest reply: Feb 22, 2013 7:07 PM by 992059 RSS

    Login Screen in Oracle forms builder 6i

    992059
      Hello everyone

      I am trying to create a canvas with a login screen and password in oracle forms builder 6i.

      So far I have create the following table:

      CREATE TABLE PASSWORD
      (USER_ID NUMBER(3)
      CONSTRAINT PASSWORD_USER_ID_PK PRIMARY KEY,
      PASSWORD VARCHAR2(20) NOT NULL);

      Inserted the following values:

      INSERT INTO PASSWORD (USER_ID,PASSWORD)
      VALUES (1,1010);

      INSERT INTO PASSWORD (USER_ID,PASSWORD)
      VALUES (2,2020);

      Created a MENU canvas with a LOGIN button TI_USER_ID and TI_PASSWORD text boxes.
      In the LOGIN button i have inserted the following WHEN-BUTTON-PRESSED trigger:

      BEGIN
      SELECT USER_ID
      INTO :GLOBAL.USER_ID
      FROM PASSWORD
      WHERE USER_ID = :LOGIN.TI_USER_ID
      AND PASSWORD= :LOGIN.TI_PASSWORD;
      GO_BLOCK('PASSWORD');
      EXCEPTION
      WHEN NO_DATA_FOUND THEN
      :GLOBAL.COUNT := :GLOBAL.COUNT + 1;
      IF :GLOBAL.COUNT = 1 THEN
      MESSAGE('wrong');
      MESSAGE('wrong');
      ELSIF
      :GLOBAL.COUNT = 2 THEN
      MESSAGE('wrong');
      MESSAGE('wrong');
      ELSIF
      :GLOBAL.COUNT = 3 THEN
      EXIT_FORM;
      END IF;
      END;

      When i try to compile that it gives an error Bad bind variable LOGIN.TI_USER_ID
      Bad bind variable LOGIN.TI_PASSWORD

      What am i doing wrong?
        1 2 3 Previous Next