Changing Key Size
Transpower at aol.com
Transpower at aol.com
Mon Aug 30 16:11:49 PDT 2004
In a message dated 8/30/2004 6:36:33 PM Eastern Daylight Time,
dave at PRIMUS.NET writes:
> Hi, I’m new to filePro. We have a customer who wants to merge 4 filePro
> databases together (identical schemas). There is a problem with the key fields
> though, because each database started at 1. So we want to prepend a value
> to the keys in each table to make them unique. So record 10000 would become
> 110000 at location 1, and at location 2 10000 would become 210000.
>
>
>
> It looks like the first task is to change the schema for each table and
> change “5 *” to “7 *” (widen the field).
>
>
>
> At first our customer asked us to write a script to edit the table/Key file
> directly. This seems like a bad idea because the file is not plain text and I
> ’m pretty sure we would corrupt it.
>
>
>
> So I guess we have two options: 1) figure out filePro processing or 2)
> export to csv, process the table with a script, re-import.
>
>
>
> Can you give me some ideas where to start? I’m confused on how to make a
> filePro script that would cycle through all the records.
>
>
>
> Is the $190 filePro book worth it?
>
>
With identical schemas, you can pick one database file and have the other
three post all their records to it (lookup file free, copy file). You could add
a field denoting the origin of the data.
Regards,
RWS
transpower at aol.com
www.transpowercorp.com
Commercial and custom software manufactuing for engineering and management
since 1976; SCO Authorized and Microsoft Certified Systems Engineering
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20040830/b135466a/attachment-0001.html
More information about the Filepro-list
mailing list