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 Rhinorhino 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
Joined
Oct 28, 2003
Messages
136
Location
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 Question
Populating Drop Downs - Error Retrieving Data
Replies
0
Views
420
LeonelSanchezJr
LeonelSanchezJr
antonioharenas
  • Locked
  • Question Question
Webfocus Error (FOC277)
Replies
1
Views
607
rasETL
rasETL
focus393
  • Locked
  • Question Question
simple focus code giving error
Replies
2
Views
496
focus393
focus393
gn090256
  • Locked
  • Question Question
write external file with webfocus
Replies
1
Views
335
jimster06
jimster06
AB09
  • Locked
  • Question Question
How to handle onchange event with database in between.
Replies
0
Views
243
AB09
AB09

Part and Inventory Search

Sponsor

Back
Top