Export problem

George Simon GSimon at americanriverintl.com
Thu Feb 8 12:21:42 PST 2007


> Yes, I did ask them to upgrade.  No luck there.

> So, my next question is - how do I get to the first
> record?  Sorry, I would normally do some testing at
> this point, but I don't have access to the 4.0 system.

> Will I be able to do a record number lookup to record
> #1, and still do a getnext - if the first lookup
> fails?  This assumes I enter the processing with the
> -xe flag.

> I suppose, if necessary, I could create a blank
> selection set before going into IUA and then use that
> to get to the first record.

> Jeff Harrison
> jeffaharrison at yahoo.com

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

I don't know if the code below would work, it depends on how filePro
selects the next record to be used from the pool of available record
numbers.  Ken?

If:
Then: rn="1"
If:
Then lookup filename r=rn -n
If: not filename
Then: gosub ADDREC1
...
...
...
...
...
ADDREC1
If:
Then:	lookup filename r=free -e
If: filename(@rn) ne rn
Then: delete filename; goto ADDREC1
If:
Then: lookup - r=rn -e
If:
Then: return




 


More information about the Filepro-list mailing list