HighTechTalks DotNet Forums  

Re: SQL Validation

Go Back HighTechTalks DotNet Forums Microsoft DotNet Framework Dotnet Framework (ODBC.net) Re: SQL Validation

Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet


Discuss Re: SQL Validation in the Dotnet Framework (ODBC.net) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Peter Murray
 
Posts: n/a

Default Re: SQL Validation - 08-22-2004 , 09:24 PM





Try to prepare the statement, which will check the syntax but won't run it.



Chris Fink wrote:

Quote:
I am using the Microsoft.Data.Odbc class to submit an SQL to TeraData using
the commandText property (SQL is stored in a string locally). Is there a way
to perform validation on the SQL syntax prior to submission to the DB? In
our environment, we submit dozens of SQL statements sequentially and I am
trying to eliminate bad SQL syntax from bombing the execution.

Any help is appreciated!


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.


Contact Us - HighTechTalks DotNet Forums - Archive - Top