C++Talk.NET C++ language newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  SQL oriented scripting language that can be executed from a          C++Talk.NET Forum Index -> C++ language (comp.lang.c++) View previous topic :: View next topic   Author Message Michal O Guest Posted: Wed Sep 22, 2004 6:23 pm    Post subject: SQL oriented scripting language that can be executed from a Hi. I have to write a C++ code that invokes a set of SQL statements (inserts, updates, selects etc.), according to the system administrator's directives. The directives should be written as a simple script. In addition to the SQL statements invocation, the script should enable using query results as an input to other SQL statements, and should be able to handle multiple query results. The script writer should be able to access informaion from the C++ program. Do you have any recommendation for a suitable scripting language, that is well integrated with C++? (I used to work with Java-->Jython and Iv'e been thinking of something similar, but for C++, and more SQL oriented). Thanks. [ See http://www.gotw.ca/resources/clcm.htm for info about ] [ comp.lang.c++.moderated. First time posters: Do this! ] Back to top Evan Carew Guest Posted: Thu Sep 23, 2004 1:11 am    Post subject: Re: SQL oriented scripting language that can be executed fro -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Part of every standard DBMS installation is something called an embedded compiler (really, an embedded precompiler). This takes your C or C++ code & compiles it with the appropriate vendor's C library calls based on the simplified SQL scripts you embedded in your code. For an example of this, have a look at PostgreSQL's embedded compiler. Evan Michal O wrote: Quote: Hi. I have to write a C++ code that invokes a set of SQL statements (inserts, updates, selects etc.), according to the system administrator's directives. The directives should be written as a simple script. In addition to the SQL statements invocation, the script should enable using query results as an input to other SQL statements, and should be able to handle multiple query results. The script writer should be able to access informaion from the C++ program. Do you have any recommendation for a suitable scripting language, that is well integrated with C++? (I used to work with Java-->Jython and Iv'e been thinking of something similar, but for C++, and more SQL oriented). Thanks. [ See http://www.gotw.ca/resources/clcm.htm for info about ] [ comp.lang.c++.moderated. First time posters: Do this! ] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFBUiKpoo/Prlj9GScRAhqQAJ4qPkai/MrzDlqcsvxWtDRRbX6jcwCfeHJa lIIKbWJHsM+K94eUNpxbPd8= =qCBx -----END PGP SIGNATURE----- Back to top Kurt Krueckeberg Guest Posted: Fri Sep 24, 2004 3:38 pm    Post subject: Re: SQL oriented scripting language that can be executed fro Quote: Hi. I have to write a C++ code that invokes a set of SQL statements (inserts, updates, selects etc.), according to the system administrator's directives. The directives should be written as a simple script. In addition to the SQL statements invocation, the script should enable using query results as an input to other SQL statements, and should be able to handle multiple query results. The script writer should be able to access informaion from the C++ program. Do you have any recommendation for a suitable scripting language, that is well integrated with C++? (I used to work with Java-->Jython and Iv'e been thinking of something similar, but for C++, and more SQL oriented). Thanks. I don't now if this helps, but if you use MySql as the database, it has a C++ API. [ See http://www.gotw.ca/resources/clcm.htm for info about ] [ comp.lang.c++.moderated. First time posters: Do this! ] Back to top Costa B. Guest Posted: Mon Sep 27, 2004 10:22 am    Post subject: Re: SQL oriented scripting language that can be executed fro I think you should provide more details. Do you want to implement a client SQL interpreter? Various DBMS systems provide several interfaces, from ODBC to low level API or the dreaded OLE DB. There are also a bunch of client libraries C++ that wrap ODBC or driver specific API in a more unified way. One of them is source pro db from roguewave http://www.roguewave.com/products/sourcepro/db/ and another one, cheaper, is sql api: http://www.sqlapi.com/ On the other hand several DBMS systems provide a SQL language that you can use to write scripts to do whatever you want: Oracle has PL/SQL, SQL Server has Transact-SQL etc. Costa "Michal O" <michalo (AT) gmail (DOT) com> wrote Quote: Hi. I have to write a C++ code that invokes a set of SQL statements (inserts, updates, selects etc.), according to the system administrator's directives. The directives should be written as a simple script. In addition to the SQL statements invocation, the script should enable using query results as an input to other SQL statements, and should be able to handle multiple query results. The script writer should be able to access informaion from the C++ program. Do you have any recommendation for a suitable scripting language, that is well integrated with C++? (I used to work with Java-->Jython and Iv'e been thinking of something similar, but for C++, and more SQL oriented). [ See http://www.gotw.ca/resources/clcm.htm for info about ] [ comp.lang.c++.moderated. First time posters: Do this! ] Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         C++Talk.NET Forum Index -> C++ language (comp.lang.c++) All times are GMT Page 1 of 1   Jump to: Select a forum C/C++----------------C LanguageC Language (Moderated)C++ Language (Moderated)C++ language (comp.lang.c++)C++ language, library and standards Non-English C/C++ Newsgroups----------------C++ (German)C++ (French)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.