<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=Windows-1252">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle18
{font-family:Arial;
color:navy;}
span.EmailStyle19
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=black face=Arial PTSIZE=10
FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;color:black;
background:white'>> You could add a field denoting the origin of the data.</span></font></p>
<p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:black;background:white'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>We considered this, but we think the
application will break when it finds two records corresponding to 10000,
because it doesn’t know about the origin field. We want to avoid changing
processing instructions during this phase.</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Can you give any advice on how to write a
script that adds a value to a certain field in each row of a table?</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----<br>
<b><span style='font-weight:bold'>From:</span></b> Transpower@aol.com
[mailto:Transpower@aol.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> </span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>Monday, August
30, 2004</span></font><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma'> </span></font><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma'>4:11 PM</span></font><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'><br>
<b><span style='font-weight:bold'>To:</span></b> Dave Andersen<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: changing key size</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'> </span></font></p>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>In
a message dated </span></font><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>8/30/2004</span></font><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>6:36:33 PM</span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> Eastern
Daylight Time, dave@PRIMUS.NET writes:<br>
<br>
</span></font></p>
<p class=MsoNormal style='margin-right:0in;margin-bottom:12.0pt;margin-left:
.5in'><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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.</span></font><font
color=black face=Arial BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span
style='font-family:Arial;color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff"
PTSIZE=10 FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;
color:black;background:white'> </span></font><font color=black face=Arial
BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span style='font-family:Arial;
color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff" PTSIZE=10
FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;color:black;
background:white'>It looks like the first task is to change the schema for each
table and change “5 *” to “7 *” (widen the field).</span></font><font
color=black face=Arial BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span
style='font-family:Arial;color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff"
PTSIZE=10 FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;
color:black;background:white'> </span></font><font color=black face=Arial
BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span style='font-family:Arial;
color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff" PTSIZE=10
FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;color:black;
background:white'>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.</span></font><font
color=black face=Arial BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span
style='font-family:Arial;color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff"
PTSIZE=10 FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;
color:black;background:white'> </span></font><font color=black face=Arial
BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span style='font-family:Arial;
color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff" PTSIZE=10
FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;color:black;
background:white'>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.</span></font><font
color=black face=Arial BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span
style='font-family:Arial;color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff"
PTSIZE=10 FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;
color:black;background:white'> </span></font><font color=black face=Arial
BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span style='font-family:Arial;
color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff" PTSIZE=10
FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;color:black;
background:white'>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.</span></font><font
color=black face=Arial BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span
style='font-family:Arial;color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff"
PTSIZE=10 FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;
color:black;background:white'> </span></font><font color=black face=Arial
BACK="#ffffff" PTSIZE=12 FAMILY=SANSSERIF><span style='font-family:Arial;
color:black;background:white'><br>
<br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff" PTSIZE=10
FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;color:black;
background:white'>Is the $190 filePro book worth it?</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:black;
background:white'><br>
</span></font><font size=2 color=black face=Arial BACK="#ffffff" PTSIZE=10
FAMILY=SANSSERIF><span style='font-size:10.0pt;font-family:Arial;color:black;
background:white'><br>
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.<br>
<br>
Regards,<br>
RWS<br>
transpower@aol.com<br>
<a href="www.transpowercorp.com">www.transpowercorp.com</a><br>
Commercial and custom software manufactuing for engineering and management since
1976; SCO Authorized and Microsoft Certified Systems Engineering</span></font></p>
<p class=MsoNormal style='margin-left:.5in'><font size=3 face=Arial><span
style='font-size:12.0pt;font-family:Arial'> </span></font></p>
<p style='margin-left:.5in'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>---<br>
Incoming mail is certified Virus Free.<br>
Checked by AVG anti-virus system (http://www.grisoft.com).<br>
Version: 6.0.737 / Virus Database: 491 - Release Date: </span></font><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>8/11/2004</span></font></p>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.737 / Virus Database: 491 - Release Date: 8/11/2004<BR>
</FONT> </P><BR>
<P><FONT SIZE=2>---<BR>
Outgoing mail is certified Virus Free.<BR>
Checked by AVG anti-virus system (http://www.grisoft.com).<BR>
Version: 6.0.737 / Virus Database: 491 - Release Date: 8/11/2004<BR>
</FONT> </P>