🚀 go-pugleaf

It should also be noted that the same code:

declare @test int
set @test = 1
raiserror('Test Error',16,1)

Does not return an error when Query1->ExecSQL is called.

Also, the following code does not return an error:
<sql>
declare @pcb_id int
select top 1 @pcb_id = pcb_id from myTable order by [datetime] desc
if @pcb_id is not null begin
  insert into marriageTable (pcb_id,myValue) Values (@pcb_id, 123)
  if (@@ERROR!=0) update marriageTable set myValue=123 where pcb_id = 
@pcb_id
end
else raiserror('Not Found',16,1)
<\sql>

There is a unique key on pcb_id in marriageTable. This should return an 
error if there is no pcb_id in myTable, but since the select succeeds, there 
is no error reported. The second pcb_id of the same value causes an error 
and is noted long enough for the update to succeed, but this error is not 
remembered or reported. There is no information available through 
SQLGetDiagField.

SQL Server 2000 on 2003. Client is Win XP.

Thoughts? I kinda' suspect the driver.