Each getter does not do a chain. The first get retrieves the record into the DB layer and stores it for future use until a different record is requested.
RHarman@xxxxxxxxxx 10/2/2007 4:38:30 PM >>>
So, does each getter do a chain? Or do you have something like....
if CustomerExists(CustNum)
wkName = GetCustName()
wkAddress = GetCustAddress()
endif
cbeck@xxxxxxxxxxxx 10/02/2007 2:23:10 PM >>>
3. We never return the entire record and have not given this as an
option. Many hours of debate went into this at the begining of our
project and we finally came to the reailzation that this is not needed,
and if we do need everything it is not anymore work, we just call the
getters for each field as they are needed.
WiltC@xxxxxxxxxx 10/2/2007 3:33:58 PM >>>
3. I'd never have my DB layer return a LIKEREC/EXTFILE DS. Instead,
it'd return a named DS like
ItemRec001 that would be defined in the copy source that included the
prototypes. So If you add a
field, you add a new DS with the new format. Basically like IBM's APIs
do. Besides which, I very
rarely return the entire record. Doing so isn't needed if you're
encapsulating properly and only
makes it to easy to break encapsulation. The only program that really
needs most of the fields in a
file is a CRUD application for a master file or a file dump type
program.
4. I wouldn't want to hire a programmer who couldn't get a very good
idea of what
getNextCustomerOrder() did by looking at the procedures name and how it
was being used without looking
at the code behind the procedures.
Charles
-------------------------------------------------
This email transmission and any documents, files or previous
email messages attached to it may contain information that is
confidential or legally privileged. If you are not the intended
recipient, you are hereby notified that any disclosure, copying,
printing, distributing or use of this transmission is strictly
prohibited. If you have received this transmission in error,
please immediately notify the sender by telephone or return
email and delete the original transmission and its attachments
without reading or saving in any manner.
The Evangelical Lutheran Good Samaritan Society.
---------------------------------------------------------
As an Amazon Associate we earn from qualifying purchases.