Question: How can I write to OS files from Oracle? Answer: Oracle version 7.3 supports directreading and writing of operating system files from within Oracle.In particular, the utl_file package enables

Question: We are building a Web-based interface for an existing database. We’reusing a SQL interpreter that runs the queries, then sends them to theserver without the need for a client

Question: My application (RIS) converts a date in an integer to store it in a Database. Integer = x seconds after 1.1.1970 (for ex., 709444800). I want to make a

Question: Occasionally I have found that after creating an executable, the bands in some of my datawindows have been repositioned to the top of that particular datawindow, causing a blank

Question: Is there a way to send email from within anOracle Power Objects application? Answer: There is not a native function to do this within OPO.However, you can use any

Question: The Crystal Reports help file contains “Pro-only Topics.” Can I use these Pro features with the Crystal Reports engine I recieved with OPO? If so, where can I find

Question: How can I add a row (recordset) so it gets inserted where it belongs, in alphabetical order? I use Jet 3.0, and when I update my database (.mdb), rows

Question: We need to search a simple three-million-record database containing names, phone numbers, accounts and dates. We will enter a phone number and must fetch the complete record, about 12,000

Question: I am using Power Objects 2.02. In the sample mldata session I cannot change any views that already exist; I come up in a view mode only. This is

Question: When using a rich text datawindow (not an rte control), is there a way to save the contents to a file as rich text, as is? In other words,

Question: I recently created a project in PowerBuilder 4.06 to regenerate my application, PBDs and .exe. When the project was completed, none of my datawindows or functions were regenerated. Why?

Question: I need to develop a program interfaced with a Sybase database. First I have to open a huge ASCII file (size ranges from 20 to 100 MB) to read

Question: I have a small application that monitors Windows’ resources GDI and users as well as controlling Windows’ exit/restart/reboot. I would like it to be able to disable/invoke the current

Question: I am trying to figure out how to pass through the Message Object or NVO address, either by reference or value, to another application entirely different from the original

Question: Okay, so PB 5.0 made the GetClickedCol method obsolete. Now how can I get the current column using the dwo argument? Answer: There is a replacement attribute for all

Question: How can I get the changed entry or selection in a drop-down picture list box?I am showing an array of available drives and types to be selected by the

Question: I have been trying to connect to our Oracle General Ledger Version 10.SC from PB5 Ent. I am accessing it from my PC running Win95 and a database that

Question: Stored procedure on WG7.3 Oracle expects three parameters. I can get OPO 2.0 to pass the params if I cite them literally as, for example, exec sql begin addnewperson(‘John’,’Quincy’,’Doe’);

Question: What type of code must be written to avoid the cryptic NOT NULL messages when records are to be added for fields already defined with NOT NULL in the

Question: I’m using Power Objects 2.1 and am trying to add a custom menu and toolbar toa report object. I’ve successfully done this withform objects by using the InitializeWindow, TestCommand

Question: Is it possible to have predefined (dynamically changeable) global variables that can hold reference to the printer name, copies, paper format, etc. and use a PrintReport() action that will

Question: How do classes communicate? If class A created one or more instances of class B and class C, how can class A keep track of all the instances of

Question: Why can’t I put a simple piece of code in the click event for a list box and have it execute? Also, how can I choose a value from

Question: Yesterday I received a description for a reality problem I must represent in my OPO-database application. It concerns the drinking water supply for a city, and the staff of

Question: Field-level validations should be done when the user visits the field. How can this be done?Interfield validations on the same screen also should be done when the user visits

Question: I have a DB log-on panel defined for my application, and the user ID is loaded from an INI file. I would like to have the cursor on the

Question: My program has two MDI forms. I have an option that allows the user to tile them horizontally or vertically. How can I tell at runtime what the max

Question: Develop an algorithm using English pseudo code Java to determine if a string of characters given by the user is palindromic.Algorithm outputs suitable message.Blank characters and punctuation should be

Question: I’ve been getting the following errors when I try to launch Delphi:“This program has performed an illegal operation and will be shut down.If the problem persists, contact the program

Question: I have a third-party component I am using to make an icon for my app in the Windows 95 system tray. This works great, except that I need to