Articles Oracle Forms, PL/SQL, Java, J2EE
Un nouveau forum francophone vient d'être créé sur l'incontournable site de Developpez.net. Il s'adresse aux étudiants/dévelopeurs APEX. Pour tous les développeurs APEX de Belgique, Suisse, Canada, Luxembourg, Afrique, etc. et ceux qui causent la langue...
Hi every Look and Feel happy user! I would like to know if you would be interested in an embeded Instant Messaging system as a new LAF version ? If you have something to say like Yes or No, feel free to answer the little poll I've just created on the...
A few months ago, I delivered the Forms Magnifier tool, capable of adjusting the Forms elements size and location at runtime, whatever the screen size is. This tool allows the application to fit any screen resolution in an heterogeneous PC pool. Today,...
I have worked on a tool capable of upgrading existing Forms module to implement the LAF projet. You can reach this tool here. It is a very beta version, and I need your participation to evaluate it with your own modules. There are so many different possibilities...
Steve Cosner have created an Oracle Forms tool that allows to debug all messages raised in a Forms application (even database messages provided by the DBMS_OUTPUT package). This is a quote of his presentation: "ZDebug is a form to help you easily create...
Here is a workaround that allows to count rows impacted by DML operations in each based block of a form. It consists in three form-level triggers and one program unit. The program unit: PROCEDURE Dml_rowcount ( PC$Mode In Varchar2 ) IS LC$Var Varchar2(100)...
I have seen an interresting question on a forum about how to calculate average on DATE columns. It is not possible to calculate average on non-numeric values: SQL> SELECT AVG( creation ) FROM paragraphes 2 / SELECT AVG( creation ) FROM paragraphes * ERREUR...
You've got children about 8 to 14 years ? They want to step on the programming stage ? Here is the new Basic language : KPL (Kid's Programming Langage) http://www.kidsprogramminglanguage.com/ For our teenagers (and maybe also you) to start the programming...
It is exactly one year since the forms-pjc-bean site was launched.It was created to offer a public place where everyone could share their Forms' Java bean samples. It is now time to make an assessment and, honestly, I would say that it is only a partial...
This is a Javabean that allows to replace the internal Oracle Forms' timer Read the article Francois
A text item key stroke interceptor A Javabean component that allows to intercept each key typed in a text field Read the paper Francois
A JTable within Forms Read the paper Francois
Here is a new JavaBean component that allows to display a HTML page inside a Forms frame. read the paper
This is a JavaBean component that allows to edit a HTML styled text Field. Read the article
This PJC extends the default button's functionality to show both icon and label. By Oleg Tishchenko from Ukraine Read the article
The purpose of this research&development unit is only to show that the VBean class allows to do anything in an Oracle Forms application. Read the article
Some of you has maybe noticed a lack of quality, after importing an image file from Forms with the Read_Image_File() built-in. Here is a Java Bean that allows to keep the original quality of an imported image. Francois
Here is a PJC that allows to set a Text item cursor from any image stored in the jar file. Read the article
Here is a Java bean that allows to transform a Forms module into a socket server. This way, it can receive messages from the outside. In this example, the messages are sent through a telnet session. Read the article
A Java bean that allows to chat on a Forms application Here is a first real application that uses the socketserver Java Bean Read the article
I often see questions about how to sort a based block on a non database column. This is a "how-to" that does the trick.
There is another question often asked, concerning how to immediatly avoid duplicated record in the same block. (by immediatly I would say before posting or committing). The technique used to solve this problem comes from the Kevin D Clarke’s calculated...
Here is a Java bean that allows to send emails with html body and local file attachments. Read the article
Here is a Java bean that allows to capture the mouse events and display the properties and methods of the clicked component. Read the article
If anybody is looking for a Forms HTML editor Java Bean, the Sferyx company have one. http://www.sferyx.com/