Tip Bank

DevX - Software Development Resource

How can I create VRML pages?

Question: What can I use to produce VRML, or can I write it like HTML? Answer: It is possible to write VRML as a purely text-based language, using a regular

DevX - Software Development Resource

Data Replication as a WAN Solution

Question: I have nine offices. I want each office to connect across aWAN and run client/server applications with all datacontained on one central server. However, we are finding the delays

DevX - Software Development Resource

Adjusting for Deleted Rows

Question: How do I create a column with a row ID that adjusts if a row is deleted?That is, if I had numbers 1,2,3,4,5,6 and I delete record 3, record

DevX - Software Development Resource

User changes

Question: I want to be able to take an action when a user changes the value of a data field, but not when the value of the field is changed

DevX - Software Development Resource

Creating Views

Question: I’ve got a “new user” question for you. Some of the tables in our databaseshave several columns containing data that’s not used very often. When I’musing ad-hoc queries, it

DevX - Software Development Resource

Differences Between Join Types

Question: What are the differences between LEFT, RIGHT, INNER and OUTER JOINS? Answer: An INNER JOIN is the most common type: It combines all the data from the tables specified

DevX - Software Development Resource

Querying a List

Question: I’ve been trying to construct a query on the databaseto see if the value in a particular field matches a long list of correct answers. For example, I would

DevX - Software Development Resource

Enumerating instances

Question: I want to use many instances of a class in my form, but can’t seem to figure out an easy way to check on the status of all the

DevX - Software Development Resource

DBMS Advantages

Question: Our business is just starting to look at using a relational databasemanagement system. We are currently using computers, but the usershave their own copies of whatever data they need