467,161 Members | 868 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

I can obtain Where clauses, order by, group by, of a consultation SQL??

I can obtain Where clauses, order by, group by, of a consultation SQL, by
means of some class similar to codemodel
Jun 27 '06 #1
  • viewed: 1609
Share:
4 Replies
Hi,
Would you mind be more precise, I;m not sure what the problem is.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Daniel R. Rossnagel" <dr*********@hotmail.com> wrote in message
news:eK**************@TK2MSFTNGP02.phx.gbl...
I can obtain Where clauses, order by, group by, of a consultation SQL, by
means of some class similar to codemodel

Jun 27 '06 #2
Daniel R. Rossnagel wrote:
I can obtain Where clauses, order by, group by, of a consultation SQL, by
means of some class similar to codemodel

Nope, you will have to manually parse the sql string.

JB
Jun 27 '06 #3
Sample

slqClass = New SqlClass("SELECT
Customer.CustomerID,Costomer.Name,Customer.ZoneID FROM customer WHERE
Customer.CustomerID>120 GROUP BY Customer.ZoneID,
Customer.CustomerID,Costomer.Name ORDER BY Costomer.Name")

string SelectField=sqlClass.SelectClause
//"Customer.CustomerID,Costomer.Name,Customer.ZoneID "
string ClauseFrom==sqlClass.FromClause // "Customer"
string ClauseWhere=sqlClass.WhereClause // "Customer.CustomerID>120 "
string ClauseGroupBy=sqlClass.GroupByClause // "Customer.ZoneID,
Customer.CustomerID,Costomer.Name"
string ClauseOrderBy=sqlClass.OrderByClause // "Costomer.Name"

Exite this ??
something similar ??
that it allows me to decomponer the SQL Select ,in order to be able to work
with the parts .

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
escribió en el mensaje news:%2****************@TK2MSFTNGP02.phx.gbl...
Hi,
Would you mind be more precise, I;m not sure what the problem is.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Daniel R. Rossnagel" <dr*********@hotmail.com> wrote in message
news:eK**************@TK2MSFTNGP02.phx.gbl...
I can obtain Where clauses, order by, group by, of a consultation SQL, by
means of some class similar to codemodel


Jun 28 '06 #4
Hi,
You will have to parse the string, not difficult to do with a Regex

Take a look at Regex.Split or Regex.Match methods.

Un saludos,
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Daniel R. Rossnagel" <dr*********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Sample

slqClass = New SqlClass("SELECT
Customer.CustomerID,Costomer.Name,Customer.ZoneID FROM customer WHERE
Customer.CustomerID>120 GROUP BY Customer.ZoneID,
Customer.CustomerID,Costomer.Name ORDER BY Costomer.Name")

string SelectField=sqlClass.SelectClause
//"Customer.CustomerID,Costomer.Name,Customer.ZoneID "
string ClauseFrom==sqlClass.FromClause // "Customer"
string ClauseWhere=sqlClass.WhereClause // "Customer.CustomerID>120 "
string ClauseGroupBy=sqlClass.GroupByClause // "Customer.ZoneID,
Customer.CustomerID,Costomer.Name"
string ClauseOrderBy=sqlClass.OrderByClause // "Costomer.Name"

Exite this ??
something similar ??
that it allows me to decomponer the SQL Select ,in order to be able to
work with the parts .

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
escribió en el mensaje news:%2****************@TK2MSFTNGP02.phx.gbl...
Hi,
Would you mind be more precise, I;m not sure what the problem is.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Daniel R. Rossnagel" <dr*********@hotmail.com> wrote in message
news:eK**************@TK2MSFTNGP02.phx.gbl...
I can obtain Where clauses, order by, group by, of a consultation SQL, by
means of some class similar to codemodel



Jun 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

33 posts views Thread by Diez B. Roggisch | last post: by
2 posts views Thread by C L Humphreys | last post: by
2 posts views Thread by m.k.ball@btinternet.com | last post: by
19 posts views Thread by (PeteCresswell) | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.