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

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

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

Question: I want to periodically check to see if a user’s database connection has been lost. How can I? Answer: First of all, a solution. You can implement periodic ‘polling’

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

Question: I’ve heard several of the arguments in favor of a server that supports datareplication. What are the potential problems? Answer: For our readers, the advantages of data replication [creating

Question: My applet draws lines. I click at the place where I want my line to start and then I click at the end of it. It draws a line

Question: How can I get the display value of a list box? Answer: In Oracle Power Objects, the Value property of the list box isautomatically set to the internal value

Question: Can you help me complete the enclosed program? A “Factorial Method”must be written. /////// File: Factorial.java /////// class Factorial { /* put factorial method here */ public static void

Question: I am currently writing an application to scan a text file for certain text keywords, and then copy the text (in between the kewords) into a new textfile. Could

Question: I am attempting to implement an applet that needs multipleframes (windows) that all belong or work under a single frame ? sort oflike an MDI application. However, each of

Question: I want to retrieve data from a database that is not associated withany objects on a form. How do I do this? Answer: A recordset is a client-side mechanism

Question: How do I limit the rows retrieved for a Power Objects report? Answer: The QueryCondition() method is not called when a report is executed,so you can only set a

Question: How can I dynamically add or delete entries from a list box, popuplist or combo box? Answer: List boxes, popup lists and combo boxes all use the Translationproperty. The

Question: I have a cancel pushbutton with the IsDismissBtn property set toTrue. When I first created the form, the push button dismissed theform. I added some code to prompt the

Question: I’m writing an MDI application that has two documents. One of the documents has multiple views, which are implemented as FormViews. Several views for the same document can be

Question: How can I convert a String type value to an integer or float?For example,String str=”155.230″;float real;real = str.HowCanIConvert???????; I’ve tried it like this:Integer aValue = new Integer(String.valueOf(“1”)); But this

Question: I’m using OPO 1.0.16 on a Mac, and want to confine all input to afield on a form. The user can change some popups on the form, but thecursor

Question: How can I let a user enter a password and hide the charactersentered? Answer: You can let the user enter characters into a field and replace theletters entered by

Question: I posted this question to Java newsgroups, but the response from experts avoids the real issue. Simple applet: import java.applet.*; import java.awt.*; public class FirstApplet extends Applet { public

Question: The AWT’s Frame class provides a setCursor method that allows me to set the cursor to one of the standard images (arrow, watch, etc.). The problem is I’m implementing

Question: I like the automatic QBF facility that comes with all default Power Object applications. Is there any way to pass the selection criteria to a report? Answer: Yes, there

Question: I believe there is a JavaScript function: ‘ShowDocument(URL,targetFrame)’ Is there a way to replicate this in Java? I realize that in the future the solution may materialize when a

Question: I have a note section on my Web page. I would like to be ableto click a radio button, and a small window with the note inside it wouldpop

Question: I’ve noticed that I cannot get any values returned to my Power Objects application from a PL/SQL block. How can I get around this? Answer: The inability to get

Question: I would like to have a simple application that exists as its own form, without being in the standard MDI frame for OPO applications. Is this possible? Answer: Right