Re: Retrieving DOS File Information from FORMS
Date: 1997/01/09
Message-ID: <32d45937.14712866_at_news.netspace.net.au>#1/1
Ellard_at_DMLIS.zynet.co.uk (Ross Ellard) wrote:
>I posted this just before the christmas break which was probably not
>the best time so have decided to post it again now that everybody
>should be returning from their christmas break in the hope that
>someone might have an answer.
>
>
>I was wondering if anybody could help me determine whether it is
>possible to meet our requirement.
>
>As part of our Forms 4.5 application we wish to put togeher an ABOUT
>form to provide the standard help information on the application/form
>itself. This is similar to the ABOUT found on many other windows
>applications.
>
>Part of the information we wish to display is about the FMX file
>itself. The FILENAME and DIRECTORY of the currently executing form has
>been extracted using standard form built ins. Proving a bit more
>difficult is determining the CREATION DATE and SIZE of the executing
>file.
>
>There would appear to be no built in to gather this specific
>information so do I have to call some standard windows DLL using
>ORA_FFI?
>
>If so what is the DLL I need and can anybody help with the calling
>syntax within PL/SQL.
>
>Any feedback would be appreciated.
>
>
>Ross Ellard.
>
Following is the README file for a WIn95 utility dll from Oracle.
Enjoy.
Developer/2000 Bonus Pack - Windows API Utility D2KWUTIL
This utility allows developer/2000 programmers (Forms, Reports and
Graphics) to make calls to various functions provided by the Windows
API direct from their applications.
The application uses ORA_FFI to interface with a custom DLL file which
contains the various API calls.
What Functions the Utility Provides:
File Dialogs (Save and Open) including Multi-Select capability
Select Printer name Dialog
Play WAV files and System Sounds
Read & Write INI's
Read and Write Registry
Environment functions:
Get DOS variable Get Windows Username Get Windows Directory Get Temp Directory
Create Temp File
WNetGetConnect
WinExec
Windows Help
Sendmessage Interface
Get Mouse Position
Delete File
Move File
Copy File
Get current Window Handle
And as a final bonus Bitwise operators for Handling Bit strings in PL/SQL What the Utility consists of:
- 32 bit DLL - D2KWUT32.DLL (32 bit) which contains all the functions
- PLL file - D2KWUTIL.PLL (for any of the products to use - NOT Forms Specific)
- Demo Application (wapidemo.fmb) + Supporting files
Installation:
The file is self extracting.
You will need to move the DLL into the Windows/system directory, or
the orawin/bin or somewhere else in the PATH, *OR* you can create the
environment variable D2KWUTIL_PATH in the ORACLE section of the
registry to point at the location of the file.
Run up the Demo it's all fairly self explanatory. The demo documents the options on most of the functions shown. See the package definition for each function for more information. Received on Thu Jan 09 1997 - 00:00:00 CET