devxlogo

Tip Bank

What is IBM’s VRML 2.0 proposal about?

Question: What are the key features of IBM’s VRML 2.0 proposal? Answer: Researchers at IBM Japan have proposed a reactive virtual environment. No Web references to the proposal were available

What is the Moving Worlds proposal about?

Question: What are the key features of the Moving Worlds proposal? Answer: Moving Worlds is VRML 2.0 proposal from a consortium of companies, formed by SGI, who are interested in

How compatible are VRML browsers?

Question: If I make a VRML page, can it be read by any browser? Answer: The original idea behind VRML 1.0 was that any VRML scene should be viewable using

Tax Problem Puzzle

Question: [Joe Celko’s Tax Problem Puzzle]I got this one from Richard S. Romley, via CompuServe. We were engaged in a debate about Sybase’s old T-SQL versus ANSI/ISO SQL-92. I assume

What does AFX stand for?

Question: I see the term “AFX” everywhere in the MFC source code.For example, “AFX_MSG_MAP”. What does it mean? Answer: I once asked this of Jeff Harbers, one of the original

Calculating Averages Using Clock Times

Question: Joe Celko’s Store Survey Puzzle]You are collecting statistical information stored by the quarter hour. What your customer wants is to get information by hour ? not on the hour.

Nested Outer Joins

Question: [Joe Celko’s Outer (JOIN) Limits Puzzle]Gerard Manko at ARI had a problem in 1994 April. They had just switched over from Paradox to Watcom SQL. The conversion of the

Comparing Aggregate Results

Question: [Joe Celko’s Promo Puzzle]Let’s assume that you have just gotten a job as the sales manager for a department store. Your database has the following two tables. One is