Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error Msg FOC1070 --- Don't know what's wrong with it

Status
Not open for further replies.
H1004

H1004

MIS
Oct 28, 2003
136
US
The error states: (FOC1070) Value for join ‘from’ field out of sequence. Retrieval ended.

Thank you
 
Sort by date Sort by votes
It's possible that the join from file is actually out of sequence, in which case sorting the file should do the trick, or it contains multiple occurrences of the join from field. If this is the case you could try MATCH instead.

 
Upvote 0 Downvote
See the JOIN BETWEEN 2 HOLD FILES FAILS thread. This will not be an issue with HOLD FORMAT FOCUS.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LeonelSanchezJr
  • Locked
  • Question
Populating Drop Downs - Error Retrieving Data
Replies
0
Views
149
LeonelSanchezJr
LeonelSanchezJr
antonioharenas
  • Locked
  • Question
Webfocus Error (FOC277)
Replies
1
Views
199
rasETL
rasETL
focus393
  • Locked
  • Question
simple focus code giving error 1
Replies
2
Views
171
focus393
focus393
gn090256
  • Locked
  • Question
write external file with webfocus
Replies
1
Views
102
jimster06
jimster06
AB09
  • Locked
  • Question
How to handle onchange event with database in between.
Replies
0
Views
86
AB09
AB09

Part and Inventory Search

Sponsor

Back
Top