Export problem

[Jeff Harrison]

--- Joe Chasan <joe at magnatechonline.com> wrote:

> On Thu, Feb 08, 2007 at 10:00:28AM -0800, Jeff
> Harrison wrote:
> > 
> > --- Joe Chasan <joe at magnatechonline.com> wrote:
> > 
> > > On Thu, Feb 08, 2007 at 08:38:36AM -0800, Jeff
> > > Harrison wrote:
> > > > Hello all.  I'm trying to generate some export
> > > > processing tables for a customer that has
> filepro
> > > > 4.0.X on a SCO Unix system.  I'm running into
> a
> > [snip]
> > > 
> > > however - if you added a screen with no
> > > user-accessible fields
> > > called "noupdate_jeff" (or some ridiculous name
> that
> > > fits within
> > > 4.0 naming limits - which may be 8 chars, not
> sure),
> > > and called
> > > the file with -xa (add records mode) on that
> screen,
> > > i suppose you 
> > > could do all processing in the one table (called
> > > with -z your-table-name
> > > as input table, -y !!! to override possible
> > > automatic) as if user 
> > > pressed <Esc><Esc> then delete the record you
> added
> > > and exit so runs 
> > > only once.
> > [snip]
> > 
> > Thanks Joe.  I do remember using a similar
> technique
> > back in the day - although I believe that it was
> used
> > as substitute for @menu.  However, this will make
> the
> > current record a new blank record, won't it?  I
> need
> > the current record to step through each record in
> the
> > given filepro file.  Do you have an old way to do
> > that?
> 
> if you can't rely on there being an index "A", why
> can't
> you loop though it by record # instead?  (and
> failing that,
> i suppose you could create a demand index as -rf was
> around
> in v4.0)
> 
> I would do lookup to current file, from record #1
> forward to end
> and do it from within lookup file name/alias,
> current record being
> a stepping-off place only.  when done, just delete
> before exit so
> that this record is not saved blank.
> 
> If using an index is better for you, and i'm not
> sure why it would
> be, i suppose you could first run a demand index on
> all records and
> run it off that, but i'm not sure 
>  
> --- - - - - - - - - - - - - - - - - - - - - - - - -

The problem with the record number lookup is that
there may be deleted records.  So when the lookup
fails I can't assume that I am done, so I will not
know when I am at the end of the file.
Also, can I count on "getnext -" working on a record
number lookup in 4.0?  

The demand index approach sounds promising.  However,
say I choose to build my indexes on field #1 - What
will happen if field #1 is zero length on some of the
files?  Will it still build a valid index that I can
use with "lookup -"?

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The fastest and
easiest ways to generate filepro exports and imports.


 
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited