| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
Can anyone tell me what to do when I get an error
message of "FOC1070 'from' field out of sequence; a026/ventet".
This occured when I attempted to ex a fex on a join between two
files. I then extracted just the fields that I wanted to
use from the guest file into a hold file and joined the hold
fil to the original host file. The fex worked as long as
I kept the recordlimit at 15 or 20 but when I attempted to
use it on the whole data base (about 300+ records) I once again
got the same error message.
Bonnie
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 255.1 | Sort it | GVAADG::PERINO | Joel PERINO @GEO | Tue Aug 22 1989 04:12 | 7 |
When you JOIN non FOCUS files (a HOLD is a non FOCUS file) the
field you join must be in sequence.
It is probably in sequence for the 15/20 first records but not
later. Try to sort it (FOCUS BY or VMS SORT).
Jo�l
| |||||
| 255.2 | great! | WMOIS::B_REINKE | If you are a dreamer, come in.. | Tue Aug 22 1989 14:35 | 3 |
Thank you, that worked perfectly.
Bonnie
| |||||