I am presently beginning the SQL section of Chapter 4 of the Base
Guide. (Progress report of sorts)
In the Query: Using Design View section, I ran into a problem went
explaining what search conditions (Criterion and OR rows) are available
and the format they require. As a result, I am suggestion an appendix be
written listing several of them, preferably the ones used fairly often
but not in the format most would know.
Ex.:
NOW() is used in Calc to enter today's date or today's time stamp.
However, CURDATE() and CURTIME() are used in a query to search for
today's date and the current time respectively.
BETWEEN ... AND ... as a search condition searches for a range. BETWEEN
#05/17/08# AND #09/30/09# searches for all dates from 5/17/2008 to
09/30/2009. This can also be written BETWEEN '2008-05-17' AND '2009-09-30'.
Many of these can be found in the hsqldb guide.pdf (HSQLDB Guide).
I'm thinking the more important ones should be included in the proposed
appendix rather than requiring people to search through the PDF file to
locate what they need.
It would be nice if some one or some people acquainted with the
search conditions of of other database programs could list for me the
search conditions most often used in them. Then I could research
possible differences and add them to the appendix. Knowing the more
common search conditions used by people in Base queries would help also.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
