Try OpenEdge Now
skip to main content
Application Migration and Development Guide
Application Development with PAS for OpenEdge : Design and Implementation Considerations : Deployment considerations : Minimizing the effects of schema changes
 
Minimizing the effects of schema changes
In the traditional client/server model where all ABL clients are connected to a database, database schema changes can invalidate r-code run by the client. In contrast, by designing your ABL client application to be independent of database schema, you can use the PAS for OpenEdge to minimize the effects of schema changes by masking the changes from the client application.
The following list identifies specific techniques you can use to shield these schema changes from affecting client applications:
*Set up database access so that it is accomplished entirely through server sessions (the client is not connected to the database and all records are transferred from the server session through temp-table or ProDataSet parameters)
*Avoid using LIKE syntax for temp-tables and variables in client application code and in procedure parameters for remote procedures
*Server session code must map data based on the new schema to the existing procedure parameters for the remote procedure