>How to use the fontionality of Visual Foxpro to
>add records
>in a table without using SCATTER/APPEND
>BLANK/GATHER?
>I WANT TO change the property control source to
>nothing AND USE INSERT SQL instead IS IT THE BEST
>WAY.

if buffering is on u can just append blank
if u'd issue a TABLEREVERT the new record won't be in the
file (as it only existed in the buffer)
no scatter and gather needed becasu u work with the "actual data" (the changes u make though are stored in the buffer)
if u have tablebuffering on - u can see the changed records
(before a TABLEUPDATE/TABLEREVERT), they have negative record numbers

make sure the RI code lets u have blank record if u use this approach

HTH

Arnon Gal-Oz