Question: What are some of the new features of Power Objects Version 2? Answer: The major new features of Version 2.0 include:New platforms – OPO will continue to support both
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
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
Question: [Joe Celko’s One In Ten Puzzle]Alan Flancman ran into a problem with some legacy system data that had been moved over to a SQL database. The table looked like
Question: [Joe Celko’s Milestones Puzzle]This puzzle, in a little different form, came from Brian Young. His system tracks a series of dates (milestones) for each particular type of service (tos)
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
Question: When I open a session to an Oracle database, I can’t see any tables other than those owned by my user name. How can I get access to tables
Question: What is the OnKey() method? Answer: The OnKey() method is a new method introduced with OPO version 1.0.16. The OnKey() method is triggered for an object whenever a user
Question: [Joe Celko’s Budget Versus Actual Puzzle]C. Conrad Cady posted a simple SQL problem on the CompuServe Gupta Forum. He has two tables, Budgeted and Actual, which describe how a