try .. catch .. not working like I expected - Mailing list pgsql-odbc

From BeemerBiker
Subject try .. catch .. not working like I expected
Date
Msg-id 7098330.post@talk.nabble.com
Whole thread Raw
List pgsql-odbc
A web project with VS8 and dotnet:  I am using the (only) SqlDataSource that
is in m$ofts toolbox for their datagrid.  All the postgre sql stuff is
grayed out in web project design.

The following generates a server error irregardless of whether I got an [x]
in the debug's enable exception handles:

try { Sql_DS.SelectCommand = "DROP TABLE '##TEMP'" } catch {};

The above works if ##TEMP exists, generats server error if it doesnt.

In looking at the object browser for Sql_DS, I do not see ".Active" nor do I
see ".Execute()" so I assume that the above statement is executed when the
assignment to the SelectCommand is run?  In other words do I have the
correct statement in the try..catch.. ?

..TIA..

--
View this message in context: http://www.nabble.com/try-..-catch-..-not-working-like-I-expected-tf2547090.html#a7098330
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


pgsql-odbc by date:

Previous
From: НФСР
Date:
Subject: When length of text data is 1.
Next
From: "David Sturtevant"
Date:
Subject: Connecting between Postgres(linux) and Access97