473,288 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

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
4 1789
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

33
by: Diez B. Roggisch | last post by:
Hi, today I rummaged through the language spec to see whats in the for ... else: for me. I was sort of disappointed to learn that the else clauses simply gets executed after the loop-body -...
1
by: Job Lot | last post by:
Is it possible to use Aggregate functions with GROUP BY Clauses on DataTable. I have a DataTable with following values: Date Amount Int Balance 1/1/2004 5000.00 50.00 5050.00...
3
by: Bill | last post by:
I'm trying to devise a query for use on SQL Server 2000 that will do what was previously done with one query in MS Access. The MS Access query was like this: SELECT Count(*) as , Abs(Sum( Like...
2
by: C L Humphreys | last post by:
Hi, Anyone have a really good reference for learning group by/having clauses in sql? I'm having real trouble getting my head around them. I can run a query with say, 2 columns, grouping by...
3
by: Steve | last post by:
I have some general catch clauses in my app as follows: try { } catch(Exception ex) { } try
2
by: m.k.ball | last post by:
Thanks Rich - that's great. Before I found this group, I thought I had a reasonable understanding of SQL (well, MySQL's implementation of it, at least) but the truth is there are great chunks that...
0
by: Yoel Mc Lennan | last post by:
Hello Group, I need to obtain recordset of an object COM made in VB6 and soon fill dataset, some idea of where is the error? Thanks. Imports System.Data Imports System.Configuration Public...
19
by: (PeteCresswell) | last post by:
I'm going over an application written by somebody else and have encountered what looks to me like nested "With"s. Is this something new with MS Access 2003 or am I losing it? Seems to me that...
2
by: Jack | last post by:
Hi, Performance-wise, is there a difference between these 2 clauses? I assume a large database... 1) With the WHERE clause: Select FLD1, FLD2, FLD3 From myFile Where FLD1 = 1 And FLD2 = 1
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.