BETWEEN mit VARCHAR (Zeichen+Zahlen)
Hallo Zusammen,
ich möchte gerne bei einem Trigger einen Select BETWEEN auf zwei Spalten (VARCHAR) gehen. Leider erhalte ich kein Ergebnis.
Tabelle ist wie folgt Aufgebaut
_ID INTEGER PK AI NN
PRIO VARCHAR(4)
ROUTE_FROM VARCHAR(8)
ROUTE_TO VARCHAR(8)
TIME_FROM VARCHAR(12)
TIME_TO VARCHAR(12)
_ID;PRIO;ROUTE_FROM;ROUTE_TO;TIME_FROM;TIME_TO;
1;1000;CAA01;CAA10;00:00:00;10:00:00;
2;1000;CAA01;CAA10;10:00:01;16:00:00;
3;9000;CAA01;CAA10;16:00:01;23:59:59;
Hier der Select
SELECT prio FROM tblPrio WHERE (curtime() BETWEEN TIME_FROM AND TIME_TO) AND ('CAA05' BETWEEN ROUTE_FROM AND ROUTE_TO)
Hier der dazugehörige Trigger:
DELIMITER $$
CREATE TRIGGER update_posdata_prio BEFORE INSERT ON tblposdata
FOR EACH ROW BEGIN
IF NEW.prio='' OR NEW.prio='0' OR NEW.prio = NULL THEN
SET NEW.prio=(SELECT prio FROM tblPrio WHERE curtime() BETWEEN time_from AND time_to AND New.route BETWEEN route_from AND route_to);
END IF;
END$$
Subject
Views
Written By
Posted
BETWEEN mit VARCHAR (Zeichen+Zahlen)
1429
August 19, 2014 09:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.