FORMULA LANGUAGE

Examples: @DbCommand (ODBC data source)
This formula uses the sample "pubs" database that is included with Microsoft SQL Server. The formula uses an ODBC driver to access the data source called PUBLISHERS, locate the table called "authors" that is owned by user "dbo," and then retrieve the list of names in the "au_lname" column for those authors who live in California and have a contract. The string CA is enclosed in single quotation marks, since it is already embedded within a quoted command string.

@DbCommand("ODBC";"PUBLISHERS";"dbo":"";"vanilla":"";  
"SELECT au_lname FROM dbo.authors WHERE contract=1 AND state='CA' ")

See Also