Re: OLE and NCA forms
Date: Thu, 17 Dec 1998 14:08:18 GMT
Message-ID: <75b38g$l5v$1_at_nnrp1.dejanews.com>
In article <36770C08.13927405_at_ataustralia.com.au>,
Andy Groves <andy_at_ataustralia.com.au> wrote:
> <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> <html>
> In response to your question on how to load data from an excell spreadsheet
> <br>to a form, here are some suggestions:
> <br>
> <br>The Data:
> <br>=========
> <br>1: Export the data from excell in ascii format.
> <br>2: Import the data into an Oracle database using:
> <br> 2a: Sqlldr (not very user
> friendly)
> <br> 2b: text_io function (Forms
> package)
> <br>
> <br>The Application:
> <br>================
> <br>1: Write a form that gets whatever information that you are after from
> the
> <br>database.
> <br>2: Deploy that form for the Web
> <br>3: Use the appletview as a thin client to run the form.
> <p>Andy Groves
> <br>Oracle Applications Business Manager
> <br> </html>
>
>
As Oracle Apps Business manager you are probably aware that the Oracle Apps forms have some validation logic in the forms themselves and other in stored procedures. I must import a large number of vendors. This module has no external API with which to load vendors. Instead of inserting into base tables I want to use all of the validation. To do this, I must some way send the data to the forms. This was no problem w/ App v10.7SC as they were fat, OLE forms. I have unsuccessfully used the Windows Clipboard to try to past the data into the forms. The applet will not recognize a tab (\t) and navigate to the next field. Instead the question mark (?) appears at the location of the tab.
clint
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 17 1998 - 15:08:18 CET