AW: SDAC_lub_TStoredProc_-_wyciaganie_Messages

Article View: pl.comp.lang.delphi

Article #347220

Back to pl.comp.lang.delphi Previous Next

#347220

From: Norbert
Date: Thu, 09 Jun 2022 08:42

33 lines
1806 bytes

ExM:
> Widze ze grupa juz wlasciwie umarla (5 watków przez prawie pól roku ;)
) ale spróbuje.
> 
> Poszukuje metody która umozliwi mi wyciagniecie komunikatów jakie
zwraca SQL w trakcie wykonywania procedury skladowanej (query z reszta
tez)
> 
> W MSSQL Management Studio wyglada to tak: 
>
https://drive.google.com/file/d/1tuGHSRBBa4XQ5A9FOw1WxvJBRp4f7fHe/view?usp=sharing

> 
> Generalnie korzystam z komponentów SDAC (Devart) ale moze to byc tez
inny.

Easy:
Alter procedure text_output
As
DECLARE @USERNAME VARCHAR(30)
Begin
 Print ,start'
	BEGIN TRAN
	UPDATE TUSER SET C_NAME = C_NAME WHERE L_ID = 1
	IF @@ERROR <> 0 BEGIN
	ROLLBACK TRAN
	GOTO EXEC_PROC
	END
	COMMIT TRAN
	SELECT @USERNAME = TOP(1) FROM TUSER
	PRINT @USERNAME
EXEC_PROC:
END

Technical Details

Message-ID: <HnBpLNyUl4Uqt5Mjnospam@invalid>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!3.eu.feeder.erje.net!2.eu.feeder.erje.net!feeder.erje.net!feeder1.feed.usenet.farm!feed.usenet.farm!news.uzoreto.com!news-out.netnews.com!news.alt.net!fdc2.netnews.com!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!peer03.ams4!peer.am4.highwinds-media.com!news.highwinds-media.com!feed.abavia.com!abe004.abavia.com!abp003.abavia.com!reseller!not-for-mail

References: <fc15ccc4-2398-4c68-af95-c75e592f4b17n@googlegroups.com>

Show Full Headers

Complete Article Headers

From: "Norbert@north-it.de" <nospam@invalid>
Newsgroups: pl.comp.lang.delphi
Subject: AW: SDAC_lub_TStoredProc_-_wyciaganie_Messages
Date: thu, 9 jun 2022 10:42:28 +0200
Message-ID: <HnBpLNyUl4Uqt5Mjnospam@invalid>
References: <fc15ccc4-2398-4c68-af95-c75e592f4b17n@googlegroups.com>
X-Newsreader: Tangysoft 5.68
Organization: www.abavia.com
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!3.eu.feeder.erje.net!2.eu.feeder.erje.net!feeder.erje.net!feeder1.feed.usenet.farm!feed.usenet.farm!news.uzoreto.com!news-out.netnews.com!news.alt.net!fdc2.netnews.com!peer01.ams1!peer.ams1.xlned.com!news.xlned.com!peer03.ams4!peer.am4.highwinds-media.com!news.highwinds-media.com!feed.abavia.com!abe004.abavia.com!abp003.abavia.com!reseller!not-for-mail
Lines: 34
Injection-Date: Thu, 09 Jun 2022 10:42:28 +0200
Injection-Info: reseller; mail-complaints-to="abuse@abavia.com"
X-Received-Bytes: 1479
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message