Yes. I was only wondering if it could be possible to map (at compile time) a sql string like select name from people where name ="Reece" ---> select(people, col<person_name>() == "Reece"); so that the "library user" specifies standard sql syntax (I am interested in using RML but am not an expert!)
One could certainly map the other way, i.e. generate a SQL string from a C++ expression. So one could implement a function that could transform a RML expression to a SQL string, that could be passed to a database. The question is whether a C++-based syntax would be preferable to a string-based syntax.
On 10/4/05, Pavel Vozenilek <pavel_vozenilek@hotmail.com> wrote:
"Jose" wrote:
One idea that could make the syntax issues more palatable is to incorporate some ideas from the soci.sf.net <http://soci.sf.net> <http://soci.sf.net> library
http://lists.boost.org/Archives/boost/2005/10/94680.php
I have not given thought to how easy it would be to implement it, but the idea is that the queries are valid sql queries and then the soci layer translates those to the more arcane syntax/es.
Simplifying and
unifying the syntax should be a good thing !
SOCI library produces string which is passed down to SQL engine for interpretation. This approach is very different from what RML does.
/Pavel
_______________________________________________ Unsubscribe & other changes: http://lists.boost.org/mailman/listinfo.cgi/boost
_______________________________________________ Unsubscribe & other changes: http://lists.boost.org/mailman/listinfo.cgi/bo> ost