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