devxlogo

Tip Bank

Flushing and Locking

Question: How can I set the flushing of rows to the database or the locking strategy used by Power Objects? Answer: Oracle Power Objects ‘supports’ two ways that rows can

Improving performance

Question: The repeater in my application seems to be very slow in populating. Is there anything I can do to improve its performance? Answer: Poor performance can be the result

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

Splitting Data Within a Column

Question: I am trying to write a report that will bring back fiveindividual pieces of data that are stored within the same column in a table. How do I do

Mail

Question: Is there a way to send mail with a mouse click? I’m working on a Mac and in Windows. Answer: You can send mail, or do virtually anything else

Dependent values

Question: I want to create a list box that will contain values based on the value ofanother list box. How can I accomplish this? Answer: A list box is populated

Inserting rows

Question: When I insert a row into a table, the results from the query that come after the row don’t show up. If I re-fetch the results, I can get

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

Adjusting for Deleted Rows

Question: How do I create a column with a row ID that adjusts if a row is deleted?That is, if I had numbers 1,2,3,4,5,6 and I delete record 3, record