Tip Bank

Question: [Joe Celko’s Quantity on Hand Puzzle]You are now the guy in charge of the company inventory. You get requisitions that tell how many widgets people are putting into a

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

Question: I’ve heard a lot of talk about “client-server architecture” ? is it something real, or just marketing hype? Answer: Indeed, client-server architecture is real. Put simply, the client-server model

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

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

Question: How do I open up a blank form – a form without any values displayed? Answer: As you probably know, you can add a DefaultCondition to your form, such

Question: Under which circumstances should I consider an object database management system (ODBMS) instead of a relational database managementsystem (RDMBS)? Answer: There are some specific types of applications that are

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

Question: What are the major strengths of a RDBMS when compared to anODBMS? Answer: Most ODBMS today are still weak in the area of security, so if you are planning