APPX is the Premier Development and Runtime Environment for Business Application Software
(Answer) (Category) FAQ's - APPX Software, Inc. : (Category) APPX Utility : (Category) APPX Development Environment : (Category) Tips & Techniques :
Adding new fileds with defualt values to an existent file
Would APPX place the default value of the new field into every existing record in the file?
We do in fact add the default value to every record when you restructure. The restructure process generates an event point that BEG/END READ's through the old file, SET's the old fields into the new structure, then WRITE's the new record. After each read, we RESTORE DEFAULT RECORD (into the new record) - that assigns the default values to all fields.
But, if you do a quick restructure (that is, you add a field to a variable-record-length file), we don't read copy the records.

[Append to This Answer]
2005-Oct-11 9:59am
Previous: (Answer) Copying Files between Databases/Versions
Next: (Answer) I have an ALPHA field with a validation table, but it allows for any value to be entered, regardless of the validation table values
This document is:
[Search] [Appearance]
This is a Faq-O-Matic 2.719.
Copyright 2003 by APPX Software, Inc. All rights reserved.