Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert Blank command
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01519468
Message ID:
01519480
Vues:
35
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform