Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

marye (TechnicalUser) (OP)
5 May 03 18:02
I have this really bugger of a problem that I've been trying assorted MATCHes & JOINs & just can't get all of the data I need to appear.  My next thought is to try to concatenate the 2 files I've produced.  Using DEFINE, I've created matching fields in both files & I've output 2 HOLD files with all fields in the exact same order.  However, I can't get them to concatenate.

I suspect that I may be running into a problem that I'm reading about in the Focus 7.0 manual that says to use Universal Concatenation.  However, I'm not being too successful in getting output trying to follow the directions for using MORE.  I'm doing something like this:

TABLE FILE F1
PRINT FIELD1 FIELD2
MORE
FILE F2
ON TABLE HOLD AS F3
END

But, the output tells me:
(FOC953)  INVALID STRUCTURE IN SUBREQUEST: ON
Only IF and WHERE clauses are allowed in the subrequest.

So, I tried changing it to:

TABLE FILE F1
PRINT FIELD1 FIELD2
MORE
FILE F2
RUN
ON TABLE HOLD AS F3
END
-RUN

But, now I get:
(FOC205) THE DESCRIPTION CANNOT BE FOUND FOR FILE NAMED: F3
BYPASSING TO END OF COMMAND

It takes forever to run this thing to try different things, so if anyone has some suggestions that they think will work here, please let me know.

Thanks!
Mary E.
mda1013 (Programmer)
6 May 03 16:35
try:

TABLE FILE F1
PRINT FIELD1 FIELD2
ON TABLE HOLD AS F3
MORE
FILE F2
END
boylan13 (Vendor)
10 May 03 13:31
Mary,

While testing, you might want to put in

IF RECORDLIMIT EQ 1

into each request.  This way you can test the syntax without having to retrieve all of the data.

-CB

Chris Boylan
Information Builders
Check out Focal Point Developer's Center
http://www.informationbuilders.com/focalpoint

marye (TechnicalUser) (OP)
10 May 03 14:25
Thanks for the responses!  They were helpful!
TRD1142 (Programmer)
7 Nov 03 18:42
Try using concatenating by using
USE
File1
File2 as File1
end
Table File File1

CA

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close