Yeah, I had to go in and remove the index file from the table to get it to work in Interactive Developement mode.
Thanks
>Hi Tommy
>This works in VFP 9 SP2
>
CLOSE DATABASES ALL
>CREATE TABLE MyTable (Id I, Field1 Char(10))
>INSERT INTO MyTable VALUES (1,"11111")
>INSERT INTO MyTable VALUES (2,"22222")
>INSERT INTO MyTable VALUES (4,"44444")
>INSERT INTO MyTable VALUES (5,"55555")
>INSERT INTO MyTable VALUES (6,"66666")
>BROWSE NORMAL
>GOTO 2
>INSERT BLANK
>REPLACE Id WITH 3, Field1 WITH "33333"
>BROWSE NORMAL
>
>
>
>
>
>
>>Hi Gang!
>>
>>I am working on a table (in developement mode). I need to insert some records (by hand) into the table in preparation to send these new tables out to customers. I wanted the new records to be IN the table at the required places so the system would not need an index to have the records in the correct order.
>>
>>When I tried to use INSERT BLANK on the table that was opened exclusively, the new record always goes to the end of the table.....
>>
>>And I tried turning off the index by issuing SET INDEX TO
>>
>>Same result.
>>
>>So, in FoxPro 8.0 SP1, has this ability been removed?
>>
>>(If I have to , I'll use an index to force them into the correct order... but the system did not require it... )
>>
>>Thanks!
Tommy Tillman A+ NetWork+ MCP