Kbase P98804: When are new records created / written in the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/08/2005 |
|
Status: Verified
GOAL:
When are new records created in the database?
GOAL:
When are new records written into the database?
FIX:
The process of physically creating or writing a newly created record into the database is delayed as long as possible.
The record is created / written when any of the following happen:
1. You try to get the rowid (or recid) of the buffer.
2. When you assign values to key fields for unique indexes. In order for index entries to be created, we have to create the record so that it has a rowid that can be put into the index(es).
3. When the record goes out of scope
4. Next iteration of a loop where you create again in the same buffer
5. Transaction ends.
6. A release statement is executed.
The record may be written more than once if you assign values to the fields multiple times or change the values you originally assigned.