Specifications

DocSTAR Level 2 Service Training Workbook Page 25
AND Created > #09/10/1999# And the created date of the document is greater than
9/10/1999
AND Created < #01/01/2000# And the created date of the document is less than 1/1/2000
As seen from the example, the common construction of an SQL statement is as follows:
[SELECT or UPDATE] FROM [TABLE]
[ACTION] based on
[CONDITION 1]
AND/OR [CONDITION 2]
AND/OR [CONDITION 3]
.
.
.
Etc.
For a list of some commonly used SQL statements, see Appendix D.
Reference
For more information please refer to the following DocSTAR Service Bulletins:
DocSTAR Service Reference Manual: Database Section
5067 DocSTAR ver. 2.30 Database
5070 DocSTAR Version 2.30 Software Notes
**DO NOT ATTEMPT TO USE EXECUTE SQL STATEMENTS OR ANY OF THE
INDEX FUNCTIONS UNLESS YOU HAVE BACKED UP THE ENTIRE
DOCSTAR DIRECTORY. **