We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

vsamadi
Posts: 9
Joined: Mon Oct 05, 2020 5:35 pm

result of SQL Query is not returned

I'm using advanced installer 17.2

Running below query does not return any result, although running the same query on sql server return a one row, one clomun result as 1.
I want to use the result to check if everything goes well or not but nothing is returned when I test my query.

Code: Select all

-- Inline SQL script
DECLARE @RESULT INT
BEGIN TRY
    BEGIN TRANSACTION 

		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = 0
		WHERE [SST_Title] = 'UpdateInProgress' AND SST_UserId = 0

		EXEC [P].[Common].[UML_Finish_WebServiceInstaller]
				@UML_UpdateType = 1, --1 webservice
				@UML_State = 1,-- 0: Inprogress, 1: Successfull, 2: Failed
				@UML_ErrMsg = 'Success'




		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '02.00.00'
		WHERE [SST_Title] = 'ApkTakeAwayVersion' AND SST_UserId = 0
		
		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '02.00.00'
		WHERE [SST_Title] = 'WebserviceVersion' AND SST_UserId = 0

		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '02.00.00'
		WHERE [SST_Title] = 'ApkPDAVersion' AND SST_UserId = 0

		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '02.00.00'
		WHERE [SST_Title] = 'ApkAdminDashboardVersion' AND SST_UserId = 0		
		
		



		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '1'
		WHERE [SST_Title] = 'WebserviceUpdateIsForce' AND SST_UserId = 0


		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '0'
		WHERE [SST_Title] = 'ApkPDAUpdateIsForce' AND SST_UserId = 0


		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '0'
		WHERE [SST_Title] = 'ApkTakeAwayUpdateIsForce' AND SST_UserId = 0


		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = '0'
		WHERE [SST_Title] = 'ApkAdminDashboardUpdateIsForce' AND SST_UserId = 0



		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = REPLACE('02.00.00','.','')
		WHERE [SST_Title] = 'DownloadedWebserviceVersion' AND SST_UserId = 0


		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = REPLACE('02.00.00','.','')
		WHERE ([SST_Title] = 'DownloadedApkPDAVersion' OR [SST_Title] = 'UpdateApkPDAVersion')  AND SST_UserId = 0


		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = REPLACE('02.00.00','.','')
		WHERE ([SST_Title] = 'DownloadedApkTakeAwayVersion' OR [SST_Title] = 'UpdateApkTakeAwayVersion') AND SST_UserId = 0


		UPDATE [P].[Common].[SystemSetting]
		SET [SST_Value] = REPLACE('02.00.00','.','')
		WHERE ([SST_Title] = 'DownloadedApkAdminDashboardVersion' OR [SST_Title] ='UpdateApkAdminDashboardVersion' ) AND SST_UserId = 0



		EXEC	[Common].[UML_UpdateWebServiceVersion_WebServiceInstaller]
		@UML_ToVersion = '02.00.00'
		
		DECLARE @SOFTWARE_VERSION VARCHAR(8)
		DECLARE @SOFTWARE_IS_FORCE BIT
		
		
		IF 'P'='P'
		BEGIN
		  SET @SOFTWARE_VERSION = '0594'
		  SET @SOFTWARE_IS_FORCE= '0'
		END
		ELSE
		BEGIN
		  SET @SOFTWARE_VERSION = '0420'
		  SET @SOFTWARE_IS_FORCE = '0'
		END		
		
		DECLARE  @VRE_ID INT
		SET @VRE_ID = (SELECT [VRE_ID]
		FROM [P].[Common].[VersionsRelationHeader]
		WHERE [VRE_WebserviceVersion]=REPLACE('02.00.00','.','') AND [VRE_SoftwareVersion]=@SOFTWARE_VERSION );
		

		IF @VRE_ID IS NOT NULL 
		BEGIN
			UPDATE [P].[Common].[VersionsRelationHeader]
			SET [VRE_WebserviceIsForce] = '1'
			WHERE [VRE_ID] = @VRE_ID
		END
		ELSE
		BEGIN
			DECLARE @VRE_WebserviceVersion NVARCHAR(20) 
			SET @VRE_WebserviceVersion = REPLACE('02.00.00','.','')
			EXEC	[P].[Common].[VRE_Insert_WebServiceInstaller]
			@VRE_SoftwareVersion = @SOFTWARE_VERSION,
			@VRE_SoftwareIsForce = @SOFTWARE_IS_FORCE,
			@VRE_WebserviceVersion = @VRE_WebserviceVersion,
			@VRE_WebserviceIsForce = '1',
			@VRE_ID = @VRE_ID OUTPUT
		END
		
		
		DECLARE @VRD_ID INT
		DECLARE @PDA_VERSION NVARCHAR(20)
		DECLARE @DASHBOARD_VERSION NVARCHAR(20)
		SET @PDA_VERSION = REPLACE('02.00.00','.','');
		SET @DASHBOARD_VERSION = REPLACE('02.00.00','.','')
		---- Version Relation Detail FOR PDA----
		EXEC	[P].[Common].[VRD_Insert_WebServiceInstaller]
		@VRD_VRE_ID = @VRE_ID,
		@VRD_Type = 0,
		@VRD_Version = @PDA_VERSION,
		@VRD_IsForce = '0',
		@VRD_ID = @VRD_ID OUTPUT
		---- Version Relation Detail FOR Admin Dashboard----
		EXEC	[P].[Common].[VRD_Insert_WebServiceInstaller]
		@VRD_VRE_ID = @VRE_ID,
		@VRD_Type = 0,
		@VRD_Version = @DASHBOARD_VERSION,
		@VRD_IsForce = '0',
		@VRD_ID = @VRD_ID OUTPUT
		
		


   COMMIT
	 SET @RESULT  = 1 
END TRY
BEGIN CATCH

    IF @@TRANCOUNT > 0
        ROLLBACK
	SET @RESULT  = 0
END CATCH

SELECT @RESULT AS RESULT


Catalin
Posts: 7853
Joined: Wed Jun 13, 2018 7:49 am

Re: result of SQL Query is not returned

Hello,

I have answered your other forum thread here:

viewtopic.php?f=5&t=46155#p118805

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”