I noticed now that your cursor name on line 4 is the same as the table it is coming from (but not the alias of the table). I get an error in VFP 3.0 doing this too.

If line 4 was

select * from table1alias into cursor

it would be okay.

I would chalk it up to experience and use aliases that are not the same as open table names.

Joe

>line1: close all
>line1: create table table1 (field1 c(5))
>line2: use in table1
>line3: use table1 in 0 alias table1alias
>line4: select * from table1alias into cursor table1
>
>
>If I run this code with vfp 5 or 6
>I get the error "Alias name is already in use."
>
>I am confused...
>
>Thanks
>Dave Mihalik
>dmihalik@stansleygroup.com

Joseph C. Kempel
Systems Analyst/Programmer
JNC