Key and Data combine.

John Esak john at valar.com
Fri Oct 22 08:23:02 PDT 2010


No, you're making it way too hard.

If, as you say, you don't need to keep @cd and @ud etc., Just createa new
ffile exactly the way you want it with the name "temp" let's say. In other
words have all the same fields, but no "data" section. Then, copy all the
records from the original ffile to the new one with a two line prc tabele in
the original file.... Let's call it mv_data.

Then: lookup temp r=free.  You will now have in the temp file a correct
"key" file and no "data" file assuming you designed it properly. 
Then: copy temp;  write temp;  end

You would run:

Rreport orig_file -fp mv_data -a -u

Then you would:

CAREFULLY edit the original file's map with a text editor  to have the
numbers between the first 4 colons look just like they do in the new "temp"
file's map.  Then, remove the orig file's key and data from the folder and
move the new temp/key file into that original file's folder. You have a
fully working file with just a key and no data, but all the old formats,
etc.  You should reindex the file at this point before you use it.

John

P.S. What I mean by edit the map with edit and the first 4 colons etc. is
this.... Is 


Windows
cd ...\filepro\origK_file
edit map

*nix
cd .../filepro/origK_file
vi map


Then change  the new "temp" file's numbering between the first 4 colons of
the first line so that the first line of orig_file's map now has the new
numbering between the colons. Leave all the other stuff on that first line
exactly the same as you find it.

map:17:27:3:161af71c:Yz4o'9;lt)M'usNp│map:20:0:2:161af71c:Yz4o'9;lt)M'usNpma
p:
      ^          ^
      ^          ^
      the first 4 colons

Leave all the rest alone.



> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
> m] On Behalf Of Kroboth, Joe
> Sent: Friday, October 22, 2010 9:52 AM
> To: filepro-list at lists.celestial.com
> Subject: Key and Data combine.
> 
> I several old filePro files.  They are in Key and Data 
> formats.  I would like to combine the key and data segments 
> to just key.   Not sure the how I can do this.
> 
> On the files where I don't need to preserve @UD, at UB etc. I've 
> tried the following.
> 
> Recreate the file only using the key. 
> Copy all records to the new file
> Copy the new blob,data,key,map and map.tmp back into original 
> directory.
> 
> The data seems to work but it the file has a creation 
> password on it. I can't seem to get by this. Is there a way 
> to get rid of this password? 
> 
> 
> On the files where I need to preserve @ud, at up etc. I have no 
> clue what to do.
> 
> Thanks.
> 
> 
> Joe Kroboth
> Chernay Printing, Inc
> joe_kroboth at chernay.com
> 
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list



More information about the Filepro-list mailing list