<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: great new wish list item, but how will it really work?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>> From: John Esak [<A HREF="mailto:john@valar.com">mailto:john@valar.com</A>]</FONT>
<BR><FONT SIZE=2>> Sent: Thursday, April 22, 2004 8:24 AM</FONT>
<BR><FONT SIZE=2>> To: filePro mailing list</FONT>
<BR><FONT SIZE=2>> Subject: great new wish list item, but how will it really work?</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Joe Chason submitted a great wish list item. I voted for it being a</FONT>
<BR><FONT SIZE=2>> "must-have". He suggests a new command like COPY called MOVE. </FONT>
<BR><FONT SIZE=2>> It would do</FONT>
<BR><FONT SIZE=2>> just that, MOVE a filePro record from one database to another </FONT>
<BR><FONT SIZE=2>> and DELETE it</FONT>
<BR><FONT SIZE=2>> from the original file. The difference being that system </FONT>
<BR><FONT SIZE=2>> maintained fields</FONT>
<BR><FONT SIZE=2>> would be "maintained" across the move. That is @cd, @ub, etc, </FONT>
<BR><FONT SIZE=2>> would not be</FONT>
<BR><FONT SIZE=2>> lost. Very important for archiving... but, the question </FONT>
<BR><FONT SIZE=2>> arises... How can</FONT>
<BR><FONT SIZE=2>> you maintain the @cd for example in the new file, when the </FONT>
<BR><FONT SIZE=2>> record needs an</FONT>
<BR><FONT SIZE=2>> @cd for that file, itself??</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I often look at my archive invoice file by @cd to see which </FONT>
<BR><FONT SIZE=2>> were the very</FONT>
<BR><FONT SIZE=2>> last records just added to it and on what day... How would I </FONT>
<BR><FONT SIZE=2>> be able to do</FONT>
<BR><FONT SIZE=2>> this if the original @cd was kept with the new MOVE command. JOe?</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> I want/need your suggested command, as you do, but how can we </FONT>
<BR><FONT SIZE=2>> deal with the</FONT>
<BR><FONT SIZE=2>> reality of how filePro works? Just lose the @cd of the </FONT>
<BR><FONT SIZE=2>> MOVE'd record in the</FONT>
<BR><FONT SIZE=2>> new file??</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> John</FONT>
<BR><FONT SIZE=2>> </FONT>
</P>
<P><FONT SIZE=2>To your wish add @md (Moved Date) and @mb (Moved By) ....</FONT>
</P>
<BR>
<P><FONT SIZE=2>Regards;</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>Jose Lerebours</FONT>
</P>
</BODY>
</HTML>