Unix Technical Forum

try .. catch .. not working like I expected

This is a discussion on try .. catch .. not working like I expected within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> A web project with VS8 and dotnet: I am using the (only) SqlDataSource that is in m$ofts toolbox for ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces odbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 03:11 AM
BeemerBiker
 
Posts: n/a
Default try .. catch .. not working like I expected


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-.....html#a7098330
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:04 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com