Since the Web versions, this package allows to manipulate text files on the Application Server machine.
To allow developers to manipulate text files on the client machine, the Webutil CLIENT_TEXT_IO equivalent was created.
These two packages are equivalent in term of functionality, but not in term of speed.
The difference comes from the network roundtrips used to transfer the data from the server to the client machine.
On the following screenshot, you can see a Forms dialog that use both TEXT_IO and CLIENT_TEXT_IO functions.
On the left part, the text file is created on the client machine with the CLIENT_TEXT_IO functions.
On the right part, the text file is created on the server machine with the TEXT_IO functions.
For this basic test case, we created a text file with 50 lines read from a database table.
It need 15 seconds to create this file on the client machine, but only one to create the file on the server machine and download it on the client machine.
So, don’t use the CLIENT_TEXT_IO functions, but generate the file on the server machine then download it on the client machine with the WEBUTIL_FILE_TRANSFER.AS_to_client() function.
This is the test table creation script:
CREATE TABLE TEST_TEXTIO
CODE NUMBER(5) PRIMARY KEY
FOR i IN 1 .. 50 LOOP
INSERT INTO TEST_TEXTIO
END LOOP ;
You can download the TEXT_IO.fmb Forms 9.0.2 test dialog here