RE: Insert a Record?

• Previous message: Dan Freeman: "Re: Insert a Record?"
• In reply to: Oscar Contreras: "Insert a Record?"
• Next in thread: Dan Freeman: "Re: Insert a Record?"
• Reply: Dan Freeman: "Re: Insert a Record?"
• Messages sorted by: [ date ] [ thread ]

Date: Mon, 15 Nov 2004 21:26:34 GMT

Hi Oscar:

Use the old INSERT command. Here is info on the INSERT command from the
VFP 3.0 Help file:

INSERT [BEFORE] [BLANK]

Arguments

BEFORE

Inserts a new record into the current table immediately before the current
record. The new record is then displayed for editing. Additional new
records can be added from within the editing window.

BLANK

Inserts a new blank record immediately after the current record. An editing
window isn't displayed.

Remarks

If INSERT is issued without the BEFORE or BLANK clauses, a new record is
added and the new record is then displayed for editing. Additional new
records can be added from within the editing window.
In Visual FoxPro, INSERT cannot be used on a table in a database that has
table or row buffering enabled, or on a table with referential integrity
rules such as triggers, primary or candidate keys, and so on. See
CURSORSETPROP( ) for more information about table and row buffering, and
see Chapter 7, "Working with Tables," in the Developer's Guide for
additional information about referential integrity.
If SET CARRY is ON, data in the current record is automatically copied into
the new record.
If the file is indexed, INSERT works like APPEND.

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

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
   http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
   http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
 
Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
   - VFP5 Mainstream Support retired June 30th, 2003
   - VFP6 Mainstream Support retired Sept. 30th, 2003

>Hi, Does anybody know how to insert a record in a free-non-Ordered Table?
>If I use append it will put the record at the of the table, but I need for
>instance at the middle of it. Any command , function or Routine You
>developed in VPF 8.0.
>thanks. Oscar Miami.

• Previous message: Dan Freeman: "Re: Insert a Record?"
• In reply to: Oscar Contreras: "Insert a Record?"
• Next in thread: Dan Freeman: "Re: Insert a Record?"
• Reply: Dan Freeman: "Re: Insert a Record?"
• Messages sorted by: [ date ] [ thread ]