>I need to add a record to a table.
>I do NOT need to read data back from table.
>
>Actually I need just a "Insert into ..." statement. But in VFP the "Insert" statement opens the table, read data to memory that can take several seconds, increase network traffic, eat memory etc.
>
>VFP 6
>Database : VFP 6
>Access to the DB : native FoxPro. (No ADO, OLEDB ... used)
INSERT INTO is supposed to be faster than APPEND BLANK, but you can try whether in your particular case, APPEND BLANK is faster.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)