just tried..

select * from safusers into cursor mikey

same error...


thanx,


Mike
>Hi Mike,
>
>I just did the same thing with a similar situation (multiple user ID names in a 25,000 row table with the field called cCreator ) and it worked like a charm.
>
>1) Can you select *all* the fields (ie, "SELECT * FROM safusers") ?
>2) Can you select all the fields to a cursor (ie, "SELECT * FROM safusers INTO CURSOR MyTest") ?
>3) Can you select ALL instead of DISTINCT (I understand that's not what you want, but it might tell us something).
>
>Evan
>
>>That didnt work either...
>>
>>However, I went as far as commenting all but one select statement out... And removed the 'INTO ARRAY' clause.
>>eg. SELECT DISTINCT safusers.INITIALS from safusers
>>
>>And I still get that error.
>>
>>This table is not opened exclusivly anywhere. I know that the
>>table is being opened beforehand. (well I know that the 'use'statement is being passed... I put a wait window before and after the 'use' statement. But I still get this error...
>>
>>
>>Thanx,
>>
>>
>>Mike Mead