On 08/27/2010 11:02 AM, Daniel Lewis wrote: > 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. > Hello Dan,
Well, I am not really sure what you are after here. If you mean common criteria then I'm not at sure how to respond. Are you just asking for a list of functions? Do you want some scenarios - End of Month Reports, All employees needing a review - that type of thing and an example of how someone might construct such a query? Drew --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
