Tip Bank

DevX - Software Development Resource

Formatting SQL Results

Question: I am trying to select data from three columns of a table listing all tables of a database. The table_name column is repeated with each separate column_namecolumn, hence the

DevX - Software Development Resource

Which VRML engines are available?

Question: Which rendering engines are used in VRML browsers and how do they affect my choice of browser? Answer: The library of functions that is used to create all the

DevX - Software Development Resource

Automatically Assigning Values

Question: [Joe Celko’s Hotel Rooms Puzzle]Ron Hiner put this question on the Watcom forum on CompuServe. He had a data conversion project where he needed to automatically assign some values

DevX - Software Development Resource

Case Sensitivity in Searches

Question: How can I ignore case when trying to SELECT allrecords that are LIKE a certain string variable? I have an employee’s name field in which the charactersare a combination

DevX - Software Development Resource

Finding the Correct Row Based on Effective Date

Question: I have a table with three columns: the firstcontains the name of the currency, thesecond contains the currency rate and the third contains the actual date when thecurrency rate

DevX - Software Development Resource

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

DevX - Software Development Resource

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