Hello,
Using Sql Server 2016, llbl v5.3 latest, adapter.
What's the best way of displaying SP progress in front end UI while calling action procedure using adapter? I have attached a sample sql sp that prints the desired progress message.
Any guidance would be much appreciated.
Thanks
CREATE PROCEDURE AdoProcess_Test1
AS
BEGIN
SET NOCOUNT ON;
DECLARE @time VARCHAR(16)
SET @time = CONVERT(VARCHAR(16),GETDATE(),114)
RAISERROR( 'Completed 25%% At %s', 2, 1, @time) WITH NOWAIT
WAITFOR DELAY '00:00:03'
SET @time = CONVERT(VARCHAR(16),GETDATE(),114) you
RAISERROR( 'Completed 50%% At %s', 2, 2, @time) WITH NOWAIT
WAITFOR DELAY '00:00:03'
SET @time = CONVERT(VARCHAR(16),GETDATE(),114)
RAISERROR( 'Completed 75%% At %s', 1, 3, @time) WITH NOWAIT
WAITFOR DELAY '00:00:03'
SET @time = CONVERT(VARCHAR(16),GETDATE(),114)
RAISERROR( 'Completed 100%% At %s', 1, 4, @time) WITH NOWAIT
END;