Thanks a lot for your opinion Hick. But the act of exposing struct Vdbe should be simple right. It's there sitting on my source code and my application needs to access it, just like it can access struct sqlite3. Can you kindly tell me how that can be done ?
P.S. I am almost always going to compile my application along with sqlite source code. Thanks Prakash On Tue, Sep 23, 2014 at 11:54 AM, Hick Gunter <h...@scigames.at> wrote: > IMHO you are going down a dark and dangerous passage. If your approach > really does require severe hacking of SQLite internals then maybe that is > an indication that you really need to change the approach or acquire a > different tool. Maybe you are trying to nail it with a set of pliers. > Doable, but not as neat as using a hammer in the first place, and also hard > on the pliers. > > -----Ursprüngliche Nachricht----- > Von: Prakash Premkumar [mailto:prakash.p...@gmail.com] > Gesendet: Dienstag, 23. September 2014 06:29 > An: General Discussion of SQLite Database > Betreff: Re: [sqlite] Expose struct Mem and struct Vdbe to other > application > > Thanks a lot for your reply Hick. > I'm trying to split the results of joins. I have one struct per table and > if I am joining 3 tables, I would like to fill the objects of the > respective structs with the values from the ResultSet in Vdbe pResultSet > and I want to do it before the callback(interface for the external > applications) is called > Is there are a way , other than using the sqlite_column_ functions, since > I have to make one function call per column, it is very costly. > Can I not expose the Vdbe and Mem structs by placing it in sqlite3.h file > like struct sqlite3,which is exposed that way ? > > Thanks > Prakash > > On Mon, Sep 22, 2014 at 8:38 PM, Hick Gunter <h...@scigames.at> wrote: > > > Use the sqlite3_column_ functions to return result fields... > > > > Or you need to use the non-amalgamation sources and integrate them > > into your build environment. Such use is probably strongly discouraged > > by SQLite developers, as the internal structures are subject to change > > without notice. Also, a given VDBE Program implements EXACTLY the SQL > > query it was prepared with and works only with EXACTLY the schema it > > was prepared against. > > > > Are you trying to implement "stored procedures"? > > > > -----Ursprüngliche Nachricht----- > > Von: Prakash Premkumar [mailto:prakash.p...@gmail.com] > > Gesendet: Montag, 22. September 2014 15:37 > > An: General Discussion of SQLite Database > > Betreff: [sqlite] Expose struct Mem and struct Vdbe to other > > application > > > > Hi, > > > > Let's assume I am writing a c code which directly invokes the > > sqlite_step statement. > > After the execution of the statement, I would like to access the > > pResultRow of Vdbe (which obtained by pVbe = (Vdbe*) pStmt ). > > > > How can I expose the struct Vdbe,Mem and the likes to external > > applications. > > Including them in the header file gave me the error "incomplete > > defintion of struct" > > > > Can you kindly help me? > > > > Thanks > > Prakash > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > ___________________________________________ > > Gunter Hick > > Software Engineer > > Scientific Games International GmbH > > FN 157284 a, HG Wien > > Klitschgasse 2-4, A-1130 Vienna, Austria > > Tel: +43 1 80100 0 > > E-Mail: h...@scigames.at > > > > This communication (including any attachments) is intended for the use > > of the intended recipient(s) only and may contain information that is > > confidential, privileged or legally protected. Any unauthorized use or > > dissemination of this communication is strictly prohibited. If you > > have received this communication in error, please immediately notify > > the sender by return e-mail message and delete all copies of the > > original communication. Thank you for your cooperation. > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___________________________________________ > Gunter Hick > Software Engineer > Scientific Games International GmbH > FN 157284 a, HG Wien > Klitschgasse 2-4, A-1130 Vienna, Austria > Tel: +43 1 80100 0 > E-Mail: h...@scigames.at > > This communication (including any attachments) is intended for the use of > the intended recipient(s) only and may contain information that is > confidential, privileged or legally protected. Any unauthorized use or > dissemination of this communication is strictly prohibited. If you have > received this communication in error, please immediately notify the sender > by return e-mail message and delete all copies of the original > communication. Thank you for your cooperation. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
