International Business Machines Corporation

Frederick Thomas Sharp

I-Shin Andy Wang

Constance Jane Nelin

Tanya Couch

John Shek-Luen Ng

Abdul Al-Azzawe

Judianto Sidik

Gerald Herman Roth

Chenhong Xia

Tom Robert Christopher

Shu-Huar Joseph Yeh

John Luen Ng

David Y Chen

William Holland Aiken

Mir Hamid Pirahesh

Curt Lee Cotner

Jy-Jine James Lin

Kehsing J Chou

Wendy Lynne Koontz

Rita S Wu

Kuo-Wei Hwang

Paul Chun-Hong Leung

Kathleen Miyoko Nojima

Michael Alan Guest

Debbani Kundu

Morgan Young

Tak Ming Lo

A method and system for providing feedback for docking a content pane in a host window is disclosed. The method and system include providing a docking map. The docking map includes a plurality of docking areas there within. The method and system also include positioning a thumbnail associated with a content pane over one of the plurality of docking areas. Finally, the method and system include providing a hotspot on the thumbnail. The hotspot indicates that the content pane can be dropped into the one docking area. The feedback enables a user to precisely dock a content pane. In addition, a user can predict the final configuration of the host window. In addition, the docking of the content pane can determine complex configurations within a host window including nested splitters and notebooks whose tabs are oriented in any direction.

Method and system for providing feedback for docking a content pane in a host window

A system for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The system eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

Testing environment for database server side logic

Techniques are provided for prioritizing a choice. A priority box associated with a choice is provided. A priority value is received as input for the priority box, wherein the priority value both selects and ranks the associated choice. The priority value is displayed within the priority box.

Technique for selecting and prioritizing choices

A method for providing a test environment for database server-side objects persistently stores a profile for a plurality of test runs for database server-side objects, where the profile comprises persistently stored test parameter values, pre-execution scripts, and/or post-execution scripts. Once the profile is created, it can be selected for subsequent test runs for one or more objects. A plurality of profiles for the objects may also be created. The method eliminates the need for a manual set up or destruction of the test environment for each test run, improving efficiency in the development of database server-side objects significantly.

A data collection and retrieval system and associated method allow the capture and replication of data presented at various Web pages into a database application through text parsing of the HTML source code of that document. The system allows the user to select one or more Web pages containing data of interest; to specify exactly which data within any page is to be captured; to specify how frequently data is to be collected; and to specify the conditions for collection and retrieval. The advantage of the system is realized through efficient, automated data collection that would otherwise be impractical. The system includes an initialization stage and an automatic execution stage. The initialization stage provides the user interface which allows the user to select the source file that contains data the user wishes to copy, target database that will receive the data, and timing criteria for automatic transfer of data. The automatic execution stage automatically transfers the data from the source file to the target database as instructed by the user in the initialization stage.

System and method for data retrieval and collection in a structured format

A method, apparatus, and article of manufacture, and a memory structure for displaying diagnostic messages is disclosed. The method comprises the steps of accepting user input into the computer, generating at least one message wherein the message comprises an associated message context, grouping the diagnostic messages according to the message context, and presenting the grouped messages to the user. In one embodiment, the messages are diagnostic messages that are generated for each instance where user input data violates an input constraint, and the messages are grouped according to the violated input constraint. The article of manufacture comprises a program storage device tangibly embodying instructions for performing the method steps defined above. The apparatus comprises a means for accepting user input into the, computer, means for generating at least one message associated with a message context, means for grouping messages according to the message context, and means for presenting the grouped messages to the user.

Formatted-item list control

A method and system for tracking a plurality of actions against at least one object by a computer system is disclosed. The method and system comprises providing an output view, wherein the output view includes a first output area and a second output area. An action list containing each of the plurality of actions is displayed in one of the first and second output areas. A user is allowed to select one action from the action list, and information associated with the selected action is displayed in the other of the first and second output areas.

Method and system for displaying actions and historical content in an output view

Providing feedback concerning a content pane to be docked in a host window is disclosed. The method and system comprises providing a description of a position of a content pane within a host window and utilizing a diagram to indicate the position and the orientation of the content pane within the host window. Docking is allowed to occur anywhere in the host window, not only in the border regions. In addition, docking positions include the positions inside the split panes. Given a vertical splitter bar, for example, the left-top, left-bottom, right-top, and right-bottom positions are available. The thumbnail feedback when docking shows how existing docking panes will be moved and resized, as well as the orientation and relative size of the resulting docking pane.

Method and system for providing feedback concerning a content pane to be docked in a host window

A sorting system and method that sorts records based on multiple fields by converting the fields to a common data type and sorting the common data type fields using a single sorting algorithm whereupon the records can be ordered based on the sorted common data type fields. The single sorting algorithm can quickly, efficiently, and accurately sort the records because the index fields have been converted to appropriate simple values in a common data type.

Sorting multiple-typed data

Self-diagnosing and self-correcting data entry components with dependency behavior

A method, apparatus, and article of manufacture for providing a programming development environment that supports the development of portable server routines. More specifically, the present invention discloses a method for storing and retrieving server routines within the database independent of any file I/O system. Also, the present invention discloses a debugging environment that allows debugging of server routines in a multi-tier environment, wherein the source code being debugged runs on the development machine.

Storing P-code in a database

A method, apparatus, and article of manufacture, and a memory structure for accepting data input into a computer is disclosed. The method comprises the steps of presenting a component to the user, wherein the component includes an input area for accepting the input data, and the component is subject to a constraint for the data, accepting user input into the component input area, and following an assistance policy associated with the component when the user input violates the value constraint. In one embodiment, the value constraint for the input data is organized according to the component content type. In another embodiment, the method comprises the steps of defining a component comprising an input area for accepting input data, associating the component with a value constraint according to a content type of the input area, and associating the component with an assistance policy selected from a set of assistance policies. The article of manufacture comprises a program storage device tangibly embodying instructions for performing the method steps defined above. The apparatus comprises a means for presenting a component including an input area for accepting user input from the user, wherein the component is subject to a constraint for the input data according to component content type, means for accepting user input into the component input area, and means for enforcing an assistance policy associated with the component when the user input violates the value constraint.

Self-diagnosing and self correcting data entry components

A method, apparatus and article of manufacture for a universal calling interface for executing a stored procedure in a computer. Parameter information is retrieved from a database catalog and the computer performs type checking against the user-entered parameters. If there is not a type mismatch then the computer executes the stored procedure without the user entering information about the parameters such as address and type.

Stored procedure universal calling interface

A method, apparatus, and article of manufacture and memory for providing a programming development environment that supports the development of Internet and Intranet applications. More specially, the present invention discloses an efficient, versatile dynamic debugger that allows platform-independent debugging of applications written in a wide variety of languages.

Dynamically debugging user-defined functions and stored procedures

A method, apparatus, and article of manufacture for passing a VisualBasic array argument to an SQL stored procedure executed by a computer. The VisualBasic array is first created in the memory of the computer and comprises an object. The array is then passed to a C or C++ function in the memory of the computer. The function to which the array is passed is declared as an alias for another function within VisualBasic. Execution of the function by the computer returns a handle for the passed array. Finally, the handle is passed to the SQL stored procedure in the memory of the computer, and is accessed by the stored procedure during execution by the computer.

Growing community of inventors

Menlo Park, CA, United States of America

Frederick Thomas Sharp