Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert a blank record in the middle of a table
Message
From
21/04/2003 03:37:45
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00779686
Message ID:
00779690
Views:
18
>I want to insert a blank record in the middle of a table (“append blank” appends a blank record at the end of the table). Does anybody know what the most efficient way is?
>

Ali, there used to be a command that worked something like INSERT BLANK BEFORE. The problem is that its very inefficient because VFP has to

a) copy all the records before the insertion point to a new file, then
b) add your new blank record, and then
c) add all the records after your insertion point, then
d) delete the original file, and then
e) rename the new file to the original name!

In other words this is a total copy of the file. This also requires exclusive access.

VFP help no longer supports this command although I am not sure if it actually still works (I'm using VFP7/8). However, it would not be difficult to create you own function to do this following the above steps.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Reply
Map
View

Click here to load this message in the networking platform