Hi,
I have another problem that has me stumped. I have a procedure that
creates several tables on the fly using SQL. Then I index them
(even though they have an ORDER BY) and set the order to the
index. Then I relate them with a SET RELATION. Most of the time
this works fine, but every once in awhile it just hangs up on
the SET RELATION like it can't do it.

I'm doing it this way:
SELECT active
SET RELATION TO SSNO INTO actvfltr, ssno INTO actvserv, ssno INTO actvjorf

The active file usually has about 100,000 records, and has no
index, it's just ordered by SSNO in the SQL select that creates
it.

Someone told me that hanging up usually has to do with a network
or a server, but today it hung up on a c: drive. We're running
Windows 2000.

Does anyone have any ideas?


Thanks a lot,
Becky