Creation Password (GRX)

[Chris Sellitto]

> > Chris said:
> >
> > Sometimes what we do here is we will take an existing file (ie.
> Gr_REDBK),
> > and copy the key, map, and indexes into another folder, for example
> called
> > REPREDBK.  What we see happen when we do this is when we access the
> file
> > REPREDBK we get a "ENTER CREATION PASSWORD FOR 'REPREDBK'" message
> > box.
> > There was no password on the original GR_REDBK file to begin with.
> Does
> > anyone know why this happens....
> >
> >
> > Scott says:
> >
> > You should use the fpcopy program provided to copy a file to a new
> file
> > name, or to rename an existing file.  That will prevent the problem
> you
> are
> > having.
> >
> > As for your current situation, I seem to remember it has something to
> do
> > with the map file getting some encrypted password in it and when you
> > directly copy it to a folder with a new name (as opposed to using
> fpcopy)
> this
> > generates the problem.  I can't remember but I believe the way to
> directly
> > edit the map (like with notepad) to remove this problem has been
> discussed
> > on this list.  I hope someone else will jump in and give you that
> procedure.
> >
> > Regards,
> >
> > Scott
> 
> If I remember this hack correctly, one would create a new filepro file
> with
> the name wanted with at least 1 field.
> 
> Then open the original map and the new in an editor and copy everything
> below the header to the new map. Make sure that you replace the first
> field
> in the new map file with the first field of the map old file so
> everything
> lines up properly. Then copy the key and data segment sizes making sure
> not
> to change the password.
> 
> Map:record length of key;record length of data:number of fields in
> key;password
> 
> map:595:0:66:bcea1c80:vgH8o(Mg&arI*}#h
> 
> In the above case, the record length is 595, the data segment is not
> used -
> zero length, 66 fields in key; then the password.
> 
> The save the new map and copy the key, data and the rest of the files
> to the
> new directory.
> 
> A lot of work when fpcopy, as mentioned above and by Ken, does this in
> a
> much easier, cleaner and faster way.
> 
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net

Thank you everyone for all the replies.  I do know about the fpcopy utility, and have used it many times in the past.  For this particular application I had forgotten that we were actually doing something similar to what Richard was describing.  I had added a new field to the database, and the file I was copying to still had the old map layout.  Richard's suggestion jogged my memory, and I was able to resolve my issue.

One question I do have is can fpcopy work from the command line with parameters?

Thanks again.

Chris