Sampling Of Sql Statements That Can Be Used With Notes
What SQL commands can be used with Notes?
Solution:
Notes 3.x
Notes 3.x supports only the SELECT SQL command. Sample SELECT statements are
listed
below. The SQL command can be used in Notes 3.x via @DbCommand formulas.
Sample SELECT Statements:
SELECT ALL FROM table
SELECT FROM table WHERE search-condition
SELECT FROM table GROUP BY columnid, columnid
SELECT FROM table HAVING
SELECT FROM table ORDER BY columnid DESCENDING
Notes 4.x
Notes 4.x supports the SELECT command (as listed above) as well as additional
SQL commands
such as those listed below. In Notes 4.x, SQL statements can be used in
@DbCommand formulas
and in LotusScript code (using the LotusScript Data Object).
Sample SQL Statements:
INSERT INTO tablename (columnid, columnid) VALUES (value, value)
UPDATE tablename SET columnid = value WHERE search-condition
ALTER TABLE tablename {ADD columnid datatype}
CREATE INDEX indexname ON tablename (columnid ASC, columnid DESC)
CREATE TABLE tablename (columnid datatype)
CREATE VIEW viewname (columnid, columnid) AS SELECT ...
DELETE FROM table
DELETE FROM table WHERE column = value
DROP INDEX indexname
DROP TABLE tablename
DROP VIEW viewname