Hi

I wonder if any body can shed any light on this one?

I have two views, which share a connection, the first view requeries it's data and ties up the connection. A second view attempts to download it's data and raises a busy style connection error.

This is fine and I have a method implemented that tests the busyness of the connection and does the right thing, this isn't the problem.

What I'm seeing is that when the second view attempts to use the connection my error handler traps the error but error() equals 0 when I would expect it to be 1526

so,

? error() = 0
? Message() = "Connectivity error [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt"
? Sys(2018) = [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt"

Does anybody know why error() returns 0 and not 1526?

issuing AErrors() places 1526 into the first array element correctly.

Anybody seen this?

Thanks, Bernard.