◄Summary► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back► ────────────────────────────────────────────────────────────────────────────── INSERT [#]filenumber%, recordvariable Usage Notes ■ INSERT has no effect on the current position. ■ Visual Basic removes trailing spaces from strings used in an insert operation. ■ DELETE, INSERT, and UPDATE operations affect all indexes in a table. Each of these operations automatically updates all indexes. INSERT or UPDATE will fail if the operation produces a nonunique index value in any index defined as unique-only. DELETE, INSERT, and UPDATE operations are not affected by SETINDEX. See: ◄DELETE Statement► ◄INSERT Statement► ◄SETINDEX Statement► ◄UPDATE Statement►