Odd ball odbc problem

Article View: borland.public.cppbuilder.nativeapi

Article #1863

Back to borland.public.cppbuilder.nativeapi Previous Next

#1863

From: Valence
Date: Mon, 28 May 2007 17:57

16 lines
1302 bytes

I suspect this is something fundamental I'm missing:

SQLExecDirect does not return an error for the following SQL:
<snip>
declare @test int
set @test = 1
raiserror('Test Error',16,1)
<\snip>

It seems that if the error occurs on the first line, then the error is 
returned. If the error occurs after the first action, it is not. That is to 
say that SQLGetDiagField tells me that there is no error as well as 
SQLExecDirect returns SQL_SUCCESS.

Any ideas?
Thanks.

Technical Details

Message-ID: <465b1803$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10cc67,65a02b53e18dcd13,start
X-Google-Attributes: gid10cc67,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Valence" <valence.crearer@Itron.com>
Newsgroups: borland.public.cppbuilder.nativeapi
Subject: Odd ball odbc problem
Date: Mon, 28 May 2007 13:57:24 -0400
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 63.163.143.187
Message-ID: <465b1803$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1180375043 63.163.143.187 (28 May 2007 10:57:23 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail