StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » I have an ExecuteScalar Question

I have an ExecuteScalar Question

Charles Thomas Blankenship — Tue, 01 Apr 2014 09:15:32 GMT

Unfortunately I cannot get an imbedded image or a code snippet to format properly so I have to format the question using Word and DropBox ... sorry.

https://www.dropbox.com/s/m9az2zk4mlihh4d/ExecuteScalarQuestion.docx

Thanks in advance.

C. T.

RE: I have an ExecuteScalar Question

Edhy Rijo — Tue, 01 Apr 2014 09:15:32 GMT

Hi Charles,

Glad it helped out.

RE: I have an ExecuteScalar Question

Charles Thomas Blankenship — Mon, 31 Mar 2014 22:52:35 GMT

Thanks Edhy:

SET NOCOUNT ON was 50% of the solution … adding the SELECT @@ROWCOUNT beforethe COMMIT TRAN was the other 50%

C. T.

RE: I have an ExecuteScalar Question

Edhy Rijo — Mon, 31 Mar 2014 20:46:19 GMT
Hi Charles,

Try adding the following at the top of your stored procedure.
[quote]SET NOCOUNT = ON[/quote]