<seijin@gmail.com> wrote in message
news:1184079463.320453.248450@d30g2000prg.googlegroups.com...
> Is it possible to return messages from T-SQL using ODBC?
>
> For example, I'm running the following basic example from Wikipedia on
> T-SQL...
>
> DECLARE @Counter INT
> SET @Counter = 10
> WHILE @Counter > 0
> BEGIN
> PRINT 'The count is ' + CONVERT(VARCHAR(10), @Counter)
> SET @Counter = @Counter - 1
> END
>
> SQLGetDiagField() says there is only 1 record and SQLGetDiagRec() only
> returns the very first bit of information: "[Microsoft][ODBC SQL
> Server Driver][SQL Server]The count is 10" It doesn't count down with
> more messages.
>
> What am I doing wrong?
>

seijin@gmail.com wrote:
> Is it possible to return messages from T-SQL using ODBC?
>
> For example, I'm running the following basic example from Wikipedia on
> T-SQL...
>
> DECLARE @Counter INT
> SET @Counter = 10
> WHILE @Counter > 0
> BEGIN
> PRINT 'The count is ' + CONVERT(VARCHAR(10), @Counter)
> SET @Counter = @Counter - 1
> END
>
> SQLGetDiagField() says there is only 1 record and SQLGetDiagRec() only
> returns the very first bit of information: "[Microsoft][ODBC SQL
> Server Driver][SQL Server]The count is 10" It doesn't count down with
> more messages.
>
> What am I doing wrong?