Re: [sqlite] Parser information

2007-08-02 Thread Dan Kennedy
On Thu, 2007-08-02 at 13:19 -0700, Rohit Mordani wrote: > Hi Ken, >Do you have an answer to what external api we can use to get the > Select parse tree? There is no such API. You are in hacking territory on this one. Dan. > > Rohit > > On 7/31/07, Joe Wilson <[EMAIL PROTECTED]> wrote

Re: [sqlite] Parser information

2007-08-02 Thread Joe Wilson
You already have the answer to your question. There's no need for badgering. --- Rohit Mordani <[EMAIL PROTECTED]> wrote: > Hi Ken, >Do you have an answer to what external api we can use to get the > Select parse tree? > > Rohit > > On 7/31/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > >

Re: [sqlite] Parser information

2007-08-02 Thread Rohit Mordani
Hi Ken, Do you have an answer to what external api we can use to get the Select parse tree? Rohit On 7/31/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- Ken <[EMAIL PROTECTED]> wrote: > > You should be using the external API calls not the internal sqlite calls > and types. > > Please po

Re: [sqlite] Parser information

2007-07-31 Thread Joe Wilson
--- Ken <[EMAIL PROTECTED]> wrote: > You should be using the external API calls not the internal sqlite calls and > types. Please point us to where you can get the Select parse tree from the external API. > > See: http://www.sqlite.org/capi3ref.html __

Re: [sqlite] Parser information

2007-07-31 Thread Rohit Mordani
Which external api should I use in that case? I just want a parsed tree of the sql statement Rohit On 7/31/07, Ken <[EMAIL PROTECTED]> wrote: > > You should be using the external API calls not the internal sqlite calls > and types. > > See: http://www.sqlite.org/capi3ref.html > > > Rohit Morda

Re: [sqlite] Parser information

2007-07-31 Thread Joe Wilson
--- Rohit Mordani <[EMAIL PROTECTED]> wrote: > So just to confirm - the Select structure (Select *p) is populated after the > call to sqlite3Select() method right? No. sqlite3Select() uses the Select tree - it does not produce it. See parse.y for the parser that builds the Select tree. See also

Re: [sqlite] Parser information

2007-07-31 Thread Ken
You should be using the external API calls not the internal sqlite calls and types. See: http://www.sqlite.org/capi3ref.html Rohit Mordani <[EMAIL PROTECTED]> wrote: Hi, This is my program... #include "sqliteInt.h" int main(int argc, char **argv){ Parse parse; Select sel;

Re: [sqlite] Parser information

2007-07-31 Thread Rohit Mordani
BTW, tempTable has 2 columns name varchar(20) and phone varchar(20) and I have 2 entries in tempTable Thanks Rohit On 7/31/07, Rohit Mordani <[EMAIL PROTECTED]> wrote: > > Hi, >This is my program... > > #include "sqliteInt.h" > > > int main(int argc, char **argv){ > Parse parse; >

Re: [sqlite] Parser information

2007-07-31 Thread Rohit Mordani
Hi, This is my program... #include "sqliteInt.h" int main(int argc, char **argv){ Parse parse; Select sel; const char *selectStmt = "select * from tempTable;"; parse.zSql= selectStmt; sqlite3Select(&parse, &sel, SRT_Discard, 0, 0, 0, 0, 0); sqlite3PrintSelect(&sel, 4

Re: [sqlite] Parser information

2007-07-31 Thread Rohit Mordani
So just to confirm - the Select structure (Select *p) is populated after the call to sqlite3Select() method right? In that case if I call sqlite3PrintSelect() after this then the statement will be printed right? Thanks Rohit On 7/27/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- Rohit Mordani

Re: [sqlite] Parser information

2007-07-27 Thread Joe Wilson
--- Rohit Mordani <[EMAIL PROTECTED]> wrote: > However, how do I pass the > SQL statement, get it parsed and populate the structure? sqlite3SelectNew() > is a function that I saw, however that just takes in the different sections > of the SQL Statement. I want to start with a user specified SQL que

Re: [sqlite] Parser information

2007-07-27 Thread Rohit Mordani
Hi Joe, Thanks a lot for pointing me to that structure and the method - I think that was something that I was looking for. However, how do I pass the SQL statement, get it parsed and populate the structure? sqlite3SelectNew() is a function that I saw, however that just takes in the different

Re: [sqlite] Parser information

2007-07-26 Thread Joe Wilson
--- Rohit Mordani <[EMAIL PROTECTED]> wrote: > I wanted to know if I can reuse the parser from sqlite. I want the > different sections of the query (like the SELECT part, the FROM part etc.) I > wanted to know if there is a parsed tree of some sorts that is the end > result of parsing (in sqlit

[sqlite] Parser information

2007-07-26 Thread Rohit Mordani
Hi, I wanted to know if I can reuse the parser from sqlite. I want the different sections of the query (like the SELECT part, the FROM part etc.) I wanted to know if there is a parsed tree of some sorts that is the end result of parsing (in sqlite) and if I can use this tree to retrieve the dif