Re: Can I access an ASCII file via Forms 4.0 under Windows?

In article <770994623snz_at_wplace.demon.co.uk>, Glenn_at_wplace.demon.co.uk (Glenn Nicholas) writes:
|> In article <xO7vH4Y.ri_clark_at_delphi.com>
|> ri_clark_at_delphi.com "Robert I. Clark" writes:
|> :Hi - I'm stumped and would appreciate your help. We're developing an
|> :application running on a PC/Windows client with Oracle 7.0 on an HP9000
|> :server. We need to retrieve some information from an ASCII file, enhance
|> :it and use its data to update Oracle tables. We originally intended to
|> :use SQL*Loader to parse the file and build a temporary table which we
|> :planned to access via PLSQL out of Forms.
|> : I just discovered, the hard way, that SQL*Loader won't run under
|> :Windows unless I run
|> :Windows/Forms in Standard Mode. This won't work in our application.
|> : Does anyone know of a way to read the contents of an ASCII file into
|> :a Forms 4.0 application? There are at least three ways I could do it with
|> :Powerbuilder but I can't find a single one for Forms.
|> : It certainly seems that you'd want a client-based tool like Forms to
|> :be able to access files so I assume there's a way.
|>
|> Forms4 can read the ascii file itself, according to the documentation.
|> There are a series of new built in procedures designed for this purpose
|> (eg. on-insert etc), and blocks have special properties to handle the
|> different data source. Haven't tried it myself though.
|>
|> --
|> Glenn Nicholas.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^??????????????????????????

really???
as far as i know, forms40 is not able to read or write any informations from ascii files!!!
forms40 has got lots of new triggers, where you can handle the default policy of forms e.g. on-insert, on-update ..... but to access an external file you have to write a user-exit! we had to do this, so i think you're wrong! well, if i'm wrong please tell me how to access a file from forms40, so we can save lots of time in future. :-)

regards

        Peter

--
Peter Kesch             Kapp & Co                  email:kesch_at_kapp-coburg.de
phone:+49 9561 866376   Callenberger Strasse 52-58
fax:  +49 9561 866103   96450 Coburg, Germany