changing key size
Fairlight
fairlite at fairlite.com
Mon Aug 30 17:18:38 PDT 2004
You'll never BELIEVE what Dave Andersen said here...:
>
> It looks like the first task is to change the schema for each table and change 5 * to 7 * (widen the field).
Only have to change the field size for the destination table. Do that
before data migration.
> Can you give me some ideas where to start? Im confused on how to make a filePro script that would cycle through all the records.
Create a processing-only report for the sources that simply takes each
record and copies the field contents to the corresponding field in a free
record in the new table. At the point where you copy the key field, alter
the value prior to writing that field to the destination record.
Run the report against all records for each source.
mark->
--
Bring the web-enabling power of OneGate to -your- filePro applications today!
Try the live filePro-based, OneGate-enabled demo at the following URL:
http://www2.onnik.com/~fairlite/flfssindex.html
More information about the Filepro-list
mailing list