Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.0.1
-
None
-
None
-
None
Description
DELIMITER $$
|
|
|
USE `dekanat`$$
|
|
|
DROP PROCEDURE IF EXISTS `Dek_ADPredmets`$$
|
|
|
CREATE PROCEDURE `Dek_ADPredmets`(IN iGroupsID INT)
|
BEGIN
|
|
|
SET @qur=" SELECT * FROM tpredmets ? ";
|
|
|
IF iGroupsID>0 THEN
|
SET @a=CONCAT("WHERE groupid=", iGroupsID);
|
ELSE SET @a=" WHERE groupid=1074";
|
END IF;
|
|
|
|
|
|
PREPARE Ad FROM @qur;
|
EXECUTE Ad USING @a;
|
END$$
|