SQLFORMS 3.0 (TRIGGER PROBLEM)

From: <huynh_at_falcon.navsses.navy.mil>
Date: 15 Jul 92 21:52:49 GMT
Message-ID: <1992Jul15.165249.240_at_falcon.navsses.navy.mil>


FIRST OF ALL, THANKS FOR READING AND I HOPE YOU CAN HELP ME! I AM WORKING ON SQLFORMS VERSION 3.0 AND I AM RUNNING INTO A STUPIDLY SIMPLE TRIGGER PROBLEM. BLOCK1

HULLNO__________	MACHCODE__________	LOCATION__________
CLASS __________	LOGREV  __________

BLOCK2
MACHNAME__________	MID__________

LET SAY I HAVE SOMETHING LIKE THE ABOVE TWO BLOCKS. AND I WHAT I WANT TO DO IS THAT AFTER THE USER ENTER THE DATA FOR THE "HULLNO," I WANT TO SEND THE CURSOR TO THE NEXT BLOCK, PARTICULARLY AT THE FIELD "MACHNAME." !!! SIMPLE RIGHT ???
WHAT I DID IS THAT I HAD A TRIGGER AT THE FIELD LEVEL ("HULLNO") ON BLOCK1.

EG.	TRIGGER: KEY-NXTFLD
  	BLOCK:   BLOCK1
  	FIELD:   HULLNO
  	TRIGGER STYLE:  V3
				TRIGGER TEXT
	GO_FIELD('MACHNAME');	I ALSO TRIED A COUPLE OF OTHER COMMANDS;
	GO_BLOCK('BLOCK2'); GO_FIELD('MACHNAME');
	NEXT_BLOCK;

WELL, THIS IS THE PROBLEM. I HAD THE DEBUG MODE TURN ON. AFTER THE DATA HAD BEEN ENTER FOR THE "HULLNO" THEN PRESS THE <RETURN> KEY, THE TRIGGER WAS ACKNOWLEDGED, BUT IT NEVER FIRES CORRECTLY. THE CURSOR INSTEAD OF JUMPING TO THE NEXT BLOCK, IT CONTINUES TO THE NEXT FIELD ON THE FIRST BLOCK.
SOME TYPE OF DATA HAD TO BE ENTER TO GET THROUGH AND THAT 'S WHAT I DID. WHEN IT RETURNS TO THE ORIGINAL STARTING FIELD ("HULLNO") AND IF I WERE TO HIT THE <RETURN> KEY AGAIN, THE TRIGGER WILL BE ACKNOWLEDGE AND THIS TIME IT WILL FIRES CORRECTLY.
IN OTHER WORDS IS THAT THE TRIGGER FIRES A BIT TOO LATE. HAVE YOU EVER ENCOUNTERED SOMETHING SIMLIAR? IF SO, I WOULD APPRECIATED IF YOU COULD SPEND SOME TIME HELPING ME OUT. THANK YOU FOR YOUR TIME. NHAN H. HUYNH, SCIENCE AND ENGINEERING APPRENTICE, NAVAL BASE, PHILADELPHIA Received on Wed Jul 15 1992 - 23:52:49 CEST

Original text of this message