Export problem

[Joe Chasan]

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 
 
--- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - ---
-Joe Chasan-                      Magnatech Business Systems, Inc.
joe at magnatechonline.com           Hicksville, NY - USA
http://www.MagnatechOnline.com    Tel.(516) 931-4444/Fax.(516) 931-1264