version 1.5
With a few lines of code, you have created an application that manipulates information on an Oracle server as easily as if it came from a 4th Dimension data file. The technique works with any input form in both the User and Runtime environments.
If you use this technique in your own applications, remember that you must modify the methods to create a perfect system of data modification. In the previous section, the link between the 4th Dimension records and the SCOTT.EMP rows was accomplished through 4th Dimension selection order numbers. If the selection order changes, as it will after a sort or deletion, the ManageContext method will not modify the correct Oracle rows. It is also not possible to modify a newly created record on the Oracle server.
To create a reliable data modification system, you must declare a primary key for the table. You can specify this attribute in your context definitions.