devxlogo

March 24, 1997

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

Check box in a repeater

Question: I want to manipulate a check box in a repeater control, but the check box is not bound to any data column. How can I do this? Answer: Every

“Null” method

Question: I want to be able to start a section of code if nothing is happening in an application. This type of ‘null’ method is useful for default tasks. How

Structured variables

Question: It seems like I cannot define my own data structures in OPO. I want to create an variable that actually consists of different underlying variables – a string followed

BLOB Data Storage

Question: What are the advantages/disadvantages of putting large binary files (1+ MB) in BLOB columns versus storing them on a file server with a reference such as a directory/file spec

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

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

Set focus

Question: When a user selects a value from a list box, I populate the contents of arepeater. I also want to set the focus into the repeater’s first field.How can

Lock Conflicts

Question: Our system is experiencing several lock conflicts. We’ve got a consultantlooking at the details, but I was hoping you could explain what’s going onbehind the scenes when records are