SQLFORMS 3.0 (TRIGGER PROBLEM)
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