PDA

View Full Version : Senior moment



Dave &/or Wempy
19-Oct-2005, 09:35 AM
I'm going to use my new Brother PTouch1180 label machine to print the
following on the wall in front of my desk.

"It's the DDF's, stupid!"

I diligently rsync my PSQL database to the test server each weekend,
and on Sunday started a big restructure job (as dbb restucture has a
few blind spots as regards dfbtrieve files).

I used
open "\\kfdb\db\kirk\register.int" as register
open "\\kfdb\db\kirk\newreg.int" as newreg
and sat back and watched. I used dbexplorer to check it was all going
well and did a years' records in each session. Finally today, closed
in case Wilma come wandering (our equivalent of a 'snow day'), got all
3.5 million records into the new format.

Looked at the newreg test server file - 40kb. Hey, that's efficient!.
Duh! it relies on the DDFs, not the .int files. As I didn't specify
the actual path it used the original copies, which occur first in the
datapath.
I'm please now that I didn't use a more destructive method to create
the new file.

Shoulda stayed in bed.