It just does nothing. I can use alt+cntl+delete to get the task list and
it shows as not responding.

I'm at 1309 Topeka, where are you?

Thanks,
Rebecca


>Hi Rebecca,
>Do you mean hang like (no error, no activity, not responding) or (blue screen) or something else.
>I mainly wanted to respond 'cause of your town.
>
>>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