Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Blank command
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01519468
Message ID:
01519480
Views:
34
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
Previous
Reply
Map
View

Click here to load this message in the networking platform