Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert before
Message
 
To
05/07/2006 11:34:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01133860
Message ID:
01133874
Views:
17
As in FoxPro2.5 for DOS Help:
*-------------------------------------------------
º INSERT º
INSERT [BEFORE] [BLANK]

Inserts a new record into a table/.DBF.
Included for backward compatibility. Use APPEND or INSERT - SQL instead

INSERT places a new record into the current table/.DBF immediately after the current record and displays the new record for editing.

If CARRY is SET ON and BLANK isn't included, data in the previous record is automatically copied into the new record.

If the file is indexed, INSERT works like APPEND.

Caution
INSERT isn't recommended for use with large tables/.DBFs because an insertion near the front of the table/.DBF forces rewriting of nearly every record. This can take a very long time. Use INSERT - SQL instead.

BEFORE
Issuing INSERT BEFORE inserts a new record into the current table/.DBF immediately before the current record. The record is then displayed for editing. Data can be entered only into the new record.

BLANK
Issuing INSERT BLANK inserts a blank record immediately after the current record. An editing window isn't displayed.

*-----------------------------------------------------------



>Hi all,
>1. What is full sintax of command: INSERT BEFORE
>
>2. How can I use it (or how to do this) to reposition one or more records in nonindexed
>table without rewriting it or mutually interchanging contents of records.Is this
>possible with drag and drop in grid ?
>
>TIA, gojko
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform