zwwcn

Just another WordPress.com site

Monthly Archives: June 2015

IOS: Redundant Binary Upload. There already exists a binary upload with build version

I had problem to upload new build to itunes connect because a build with same version and build number already exist in Itunes connect. Itunes connect don’t allow you to remove old build, I need to overwrite the existing one otherwise I will leave old builds under my apps. the solution is to add extra part to the build number: 1.3.3 becomes 1.3.3.1, you don’t need to change the version number.

MySQL Procedure single loop example

DROP PROCEDURE IF EXISTS `create_string_field_options`;
DELIMITER //

CREATE PROCEDURE create_string_field_options()
BEGIN

DECLARE franchiseId bigint(20);
DECLARE no_more_rows BOOLEAN;
DECLARE franchise_cur CURSOR FOR
SELECT
OBJECT_ID
FROM OP_FRANCHISE
WHERE REC_STATUS="A" AND ORGANISATION_TYPE IN ("RF","RO");

DECLARE CONTINUE HANDLER FOR NOT FOUND
SET no_more_rows = TRUE;

OPEN franchise_cur;

the_loop: LOOP

FETCH franchise_cur
INTO franchiseId;

IF no_more_rows THEN
CLOSE franchise_cur;
LEAVE the_loop;
END IF;

INSERT INTO OP_STRING_FIELD_OPTION VALUES(getNextObjectID(),'TypeName',franchiseId);

END LOOP the_loop;

END
//
DELIMITER ;