Roguewave makes a well known C++ wrapper for SQL. For example to
delete rows in a theoretical movie reservation system one can write:
// C++ code
int videoID = 1234;
std::string lastName = "Miller";
RWDBTable purchases = myDbase.table("purchase");
RWDBDeleter deleter = purchases.deleter();
deleter.where(purchases["videoID"] == videoID && purchases["last_name"]
==lastName);
deleter.execute(myConnection);
// above does delete from purchase where videoID==123 and
last_name='Miller';
Question: are there any papers which might explain how the C++
expression:
purchases["videoID"] == videoID && purchases["last_name"]
==lastName
can be mapped to the string where videoID==123 and
last_name='Miller' ? Note that the operator == could have been != and
the C++ operator && could have been || to give:
delete from purchase where videoID!=123 or last_name='Miller';
Thank you in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
