Re: validate sql syntax
From: Sharon (talsharon_at_hotmail.com)
Date: 04/10/04
- Next message: MS News \(MS ILM\): "Netscape & IE"
- Previous message: chris: "Re: problem updating my database"
- In reply to: Jarod_24: "Re: validate sql syntax"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 10 Apr 2004 22:11:51 +0200
it is not clear from what you wrote, whether you are using
a single method for all types of data access,
or that you are trying to validate a query for a specific type of data
access
in a specific method.
usually different methods are used for different types of data access.
you don't even have to implement it.
check out Data Access Application Block for .NET:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp
"Jarod_24" <jarod_24@hotmail.com> wrote in message
news:62fcb500bb34e90bea33c19387893d44@news.teranews.com...
>
> "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.
> > >
> > >
> > >
> > >
> >
> >
>
>
- Next message: MS News \(MS ILM\): "Netscape & IE"
- Previous message: chris: "Re: problem updating my database"
- In reply to: Jarod_24: "Re: validate sql syntax"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
