March 24, 1997

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

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

Normalized Database: When to Split?

Question: We have several heavily-used tables with lots of columns (average around 30 columns), and the users are getting locked out frequently. We’ve thought about splitting the tables, but didn’t

Column lengths

Question: Data field objects in OPO can accept any amount of data, but if I send too many characters to the server, I get an error “flushing the row to

How are transactions handled in OPO?

Question: How are transactions handled in OPO? Answer: Transactions are the core of multi-user data processing integrity. A transaction defines an all-or-none unit of work. The classic example of a

SQL parsing error

Question: I have been having a lot of trouble with a SqlLookup() function. Whenever I use a WHERE clause, I get a parse error.The offending WHERE clause is “WHERE SW_LICENSE

Join Performance

Question: I’m wondering whether it would be faster to join a large table to a small table by placing the large table on the left side or theright side of