Re: validate sql syntax

From: Jarod_24 (jarod_24_at_hotmail.com)
Date: 04/10/04 

Date: Sat, 10 Apr 2004 17:45:35 GMT

"Sharon" <talsharon@hotmail.com> wrote in message news:%237hnnZwHEHA.3356@TK2MSFTNGP11.phx.gbl...
> do you use a single method for all types of query?

?!?!
I am asking if there exists a method to do this.

>
> "Jarod_24" <jarod_24@hotmail.com> wrote in message
> news:97d07e4d3e8d763ec7134e1c9c87d0a3@news.teranews.com...
> > How do i check if a sql-string has corect syntax.
> >
> > With select-statements you can just use a Datareader, since no data is
> changed in the database, but i'm working with other
> > statements as well, and need to just verify that the syntax of the string
> is correct, and determine if it is a select, update,
> > insert or delete statement.
> >
> > I've looked but can't seem to find a class that does this.
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: validate sql syntax
    ... or that you are trying to validate a query for a specific type of data ... usually different methods are used for different types of data access. ... >> do you use a single method for all types of query? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: pass arguments to function
    ... VB syntax is funny. ... argument list of a sub procedure. ... >I am passing values for search criteria, query and sort order for the query ... >Public Sub QuickSearch(strSearch As String, qry As String, ord As String) ...
    (microsoft.public.access.modulesdaovba)
  • Re: File named rename problem. Strange characters.
    ... Surely you don't expect us to believe that the entire implementation of your system is contained in the single method "Download". ... You can use Uri.UnescapeDataString() to convert string with '%'-escaped characters back to the original, but note as the documentation for that method states that the '+' characters won't be modified. ... In any case, as I said, until you provide a concise-but-complete code sample, it's unlikely anyone will be able to provide an exact answer. ...
    (microsoft.public.dotnet.languages.csharp)
  • Replace-Function with Sybase?
    ... as varchar. ... the attribute I need to query for is a string with 30 Digits. ... " Incorrect syntax near the keyword 'REPLACE'. ...
    (comp.databases.sybase)
  • Using a VB.NET DLL
    ... I want tu use a single method of a VB.NET DLL from VC++.NET. ... I just need object creation and method call syntax. ...
    (microsoft.public.dotnet.languages.vc)