Tip Bank

Question: I want to use a string variable with the date in it (format would be 02/22/96). How do I accomplish this? Answer: You’ll need to first convert the date

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: 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: 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: 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