Tip Bank

Question: [Joe Celko’s Personnel Problem Puzzle]Daren Race was trying to aggregate the results from an aggregate result set using Gupta’s SQLBase and could not think of any way other than

Question: We are putting together a book with contributions from many Anthologies (identified by their contrnum). We want to find all Anthologies thathave articles in exactly two out of three

Question: I have an employee table with a field empno (employee number) and an hours table that contains all time that is worked by all employees.The hours table has the

Question: When I set the FormatMask property for a data field object, the value of the field is formatted when a user enters data and tabs out of the field.

Question: The Situation: I need to define some queries to extract data from an existing database (I am using MS Access 2.0). It consists of only two tables, from which

Question: What is Embedded SQL, and howis it used with the C language? Answer: As the name implies, Embedded SQL describes SQL statements that are embedded in a host language.

Question: What are some of the new features of Power Objects Version 2? Answer: The major new features of Version 2.0 include:New platforms – OPO will continue to support both

Question: How can I define a function that is not associated with a particular form? Answer: You can define an function that is not associated with a particular form by

Question: I want to use a string variable with the date in it (format would be 02/22/96). How do I accomplish this? Answer: You’ll need to first convert the date