14.4.3 Object-Oriented Data Manipulation Language (OODML)

The OODML is designed to be powerful and expressive, while remaining familiar to users of the FDML. To achieve this aim, some of the functions and macros in the SQL interface have been overloaded -- particularly theselect function and the iteration constructs.

list-classes

Function

list-classes &key database

Thelist-classes function returns a list of the class objects of the CLOS classes which have been defined bydef-view-class for database.

select

Function

select selections &rest args &key all set-operation distinct from where
       group-by having order-by database

Theselect function is common across the both the functional and object-oriented SQL interfaces. If selections refers to a view class by supplying its symbolic name then the select operation becomes object-oriented -- returning a list of instances instead of a list of attributes. The symbolslot-value is a valid SQL operator for use within the where clause.

---

LispWorks User Guide - 14 Oct 1998

Generated with Harlequin WebMaker